One form Many tables. Please..Help.

[Frodo]

I had about 6 forms and 6 tables which were all connected.

I took my 6 form and made one form out of it.

My problem now is how can I connect all these tables to this one form.

I have tried to connect these tables the same way as I connected the 6 forms to the 6 tables but nothing working.

Is there a simple solution in access that will alow me to connect these 6 tables to this one form so the id will follow from one table to the next and so on.

This is a project I have to hand in and I need help fast.
Thanks
Frodo

 

[GohDiamond]

Use a Select Query to pull from all 6 tables. Your tables must have a relationship to one another. 1-2, 2-3, 3-4, 4-5, 5-6

Then create the select query:
SELECT Table1.Table1ID, Table1.[Field 1], Table1.[Field 2], Table2.Field3, Table2.Field4, Table3.Field5, Table3.Field6, Table4.Field7, Table4.Field8, Table5.Field9, Table5.Field10, Table6.Field11, Table6.Field12
FROM ((((Table1 INNER JOIN Table2 ON Table1.Table1ID = Table2.Table2ID) INNER JOIN Table3 ON Table2.Table2ID = Table3.Table3ID) INNER JOIN Table4 ON Table3.Table3ID = Table4.Table4ID) INNER JOIN Table5 ON Table4.Table4ID = Table5.Table5ID) INNER JOIN Table6 ON Table5.Table5ID = Table6.Table6ID;

Base the FORM on the QUERY Not on the tables. if you must use the tables then you have to set the relationships in Tools\Relationships

Hope that helps,

Goh