Quick summary: I want help with Infopath (2007) accessing multiple tables in Access (2007).
Primary Table: Warranty
Secondary Table: Inventory

I want the user to select a device from a dropdown and have a few descriptive detailed fields populate on the form based on what they selected.
This will pull from Table: Inventory.



I want the user to input an issue, and hit submit for a new record. The new record will go into a Table: Warranty (primary form in this scenario). Which just basically keeps a history of where it’s been and what issue’s it has had.

1. The first thing I want to figure out is how to make the queried results (the description fields from Table: Inventory) and use it as part of the new record for Table: Warranty.

2. The second thing is a technical problem. I can use a drop down and have the values pre-filled in using Table: Inventory which is good, but the results when I query only show results if the same device name exists in Table: Warranty.

Lastly, yes I read http://office.microsoft.com/en-us/ac...001119950.aspx