Add records to many linked tables while seeing them all (1 Viewer)

[FJRDC]

Hi
I'm new to Access2007. I created 5 tables all related to each other in series with one-to-many joins (type 2 and all enforcements on).
So an Id in table 1 can show up several times in table 2, and the same is true from tables 2 to 3, 3 to 4 and 4 to 5.
I want to enter new records in such way that I can see all tables at once. I tried to do that with a query, but I can only modify records, not add new ones.
I have no problem adding records to individual tables but have not figured out how to do it to this All-tables query. Can somebody help?
Thanks
Joe

 

[khodr]

You can create forms and then add the forms to one form as sub forms where you link each form to other related form where every form will have one deatil and other form have many this is just a guess I haven't try it to see how it could work check it out

 

[FJRDC]

Thanks, that works! Joe