Updating 3 tables with entry on 1 table

[PATRICKPBME]

I have a database with 3 tables. I have linked the tables by the contract numbers in each table. When I run queries I am getting the results that I want. there is one thing at this point I can't see to figure out.

I want the tables to communicate with each other so that when I change or add a new contract number to the primary table it adds it to the other two tables. I thought setting the relationships to referential integrity, cascade up might do this but it is not. I have set the relationships up with every combination I can think of but nothing makes the change or addition take effect.

I am going to create a form to make data entry simple but only want to have to put in the contract number once on the form to have it inserted in all 3 tables. The tables have a one-to-one relationship if that makes any difference.

[June7]

No, just setting relationships will not create dependent records.

Set subform container Master/Child Links properties. As soon as any data is entered into a field of subform, the primary key from main form will populate to foreign key field of subform.

[PATRICKPBME]

Thank you very much.