Multiple Tables in a form

G

GregB

First let me describe my situation. I have one table that is called invoices,
it is linked to a table called inventory which is linked to a table called
reclaimed machines.

I can create a form that shows the invoice and inventory related to the
invoice table

But I want to add in information from reclaimed machines that is related to
the invenotry information.

How would I make that work?
if you need more clarification let me know.
 
B

Beetle

Create a form based on your reclaim table and make it a subform of the
Inventory subform. So the structure would be something like;

Invoice Form (main)
Inventory Subform (child of Invoice Form)
Reclaim Subform (child of Inventory subform)

HTH
 
Top