From Access query to Access table via Infopath form

[KWhamill]

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?

 

[Clay Fox]

Hey There.

Are you using the default, basic database connectivity in InfoPath? Where
you design the form around a table? if so then you can only query and submit
to one table structure.

If you moved to SQL and web servies you could perform any dynamic query you
wanted and have multiple submits and queries.

Otherwise you would need to use code to get the data. You would figure out
the select statements that worked and then replicate them in code.