Design Find Record Form

[vmattjo]

how do I design a find form looking at information from 3 tables, the display result in main db form?

 

[cghoga]

1 Relate your 3 tables with primary & foreign keys (if they are not related, consider including all fields in one single table, if this is possible for your scenario.)
2 Create a query selecting the 3 tables in your query design view.
3 Join the tables (click and drag from one key to the other) based on your relationships (i.e. ID from table 1 to ID_ForeignKey in table 2).
4 Select the fields from the tables (double click on the fields or click and drag to bottom section area) you want to see in the end result.
5 Save query.
6 Create a form.
7 Set the record source of the form to the query you built.
8 Pull the fields to the form you want to see when the form is run.

hope this helps.