Synchronizing Several Tables Together

[Guest_imported]

I am about to pull my hair out! I'm not a VB programmer and don't pretend to be ... so if you can, please help ASAP. I have several tables that are all linked properly, but when I attempt to get them synchronized, I just can't get it to work. Thanks in advance. Example:

Application Table
PK=App_Id
F1=App_Date
F2=App_Type

Excavation Table:
PK=Site_Id
F1=App_Id
F2=Address1

Restoration Table:
PK=Rest_Id
F1=Site_Id
F2=Address1

Inspection Table:
PK=Inspect_Id
F1=Site_Id
F2=Rest_Id
F3=Inspector_Id

 

[JerryDennison]

What do you mean "get them synchronized"? What is the nature of the problem you're having?

 

[Guest_imported]

Sorry for the miscommunication. When I'm entering data in one form, the next form is simply an extension of the first form. The information, however, is in two different tables. Hopefully this makes sense. I can send you my table's if you'd like. Thanks again.

 

[JerryDennison]

Do you have your form's linked properly? The linkChild and LinkMaster field properties must be set for the subform(linked table). You may send the tables and form if you'd like.

jerry@athree.com