livingNcolorado said:
Thats my story in a nutshell!... And I think my answer is somewhere in "Primary Keys".. Correct??
Thats right...
1) Create a home table with all the info you want to store about the home.
2)Make sure in this table you have a field called HomeID (autonumber is probably best for what you want here). Set that field to be the "Primary Key" (unique identifier) by right clicking the grey square to the left of the HomeID field and choosing primary key.
3) Create a work order table (with WorkOrderID as a primary key- again an autonumber) and create fields for all the work order details there.
4) in a new field in the work order table choose "lookup wizard" from the data type drop down box. This will start the lookup wizard. Choose "Look Up data from table or query" then point the wizard to the HomeID field in the Home table.
5) Create forms for both tables using the wizard.
6) Open the Home form in design view.
7) create space at the bottom of the form and then click on the "subform/Subreport" tool and add a subform. The wizard should start.
8) Choose "Use an existing form" and point it to your Work Order form.
9) Choose "Link forms with HomeID" (access should automatically pick this up)
10)Finish the wizard and you should have the basis of what you want.
The subform will only show Work Orders that relate to the Home displayed in the main form.
HTH,
Tom