I am using an Access append query to pull data from a linked table and add it
to an Access table so that the users can then use info path to fill out forms
and print or email or do whatever. What i would like is for Infopath to
access a select query based on the same data in the linked tabled and and
allow the users to add the fields that they need to add and then submit the
data to the table after they have printed the form or emailed or whatever
they do. I have a tried a few different formulas for incorporating the select
query but it either won't submit the data to the table or only provides the
top result from the query.
Am I doing something wrong or impossible?