Form to table data

[Mike]

Firstly I'd like to thank all of those helping guys like me. Thanks a
million, you're helping more than you think. This is the scenario. I have
three tables which were automatically turned into forms.

Table 1 = ChanceryTable
Table 2 = ProtocolTable
Table 3 = CoupleTable

I start out at a form (Protocol Form) that works from the "Protocol Table".
When I go to the Couple's Form (working off the CoupleTable) from the
Protocol Form I'd like for the newly created "Protocol Number" to be
consistent with the new couple info that is going to be added to the
CoupleTable Form.

I have the "ProtocolIndexID" in both the Couples and Protocol table. But
the only time the information from the Protocol Table is updated is when I
manually change the "ProtocolIndexID" number within the Couples Table. Is
there a way I can have it connect to the couples information automatically
when I create the new Protocol Number?

I hope this makes sense and if I"m leaving something out please let me know
to be more specific. In a bind and hope to get some help soon. Thanks!

 

[Mike]

Yes there are relationships between all three tables.

Table 1 (ChanceryTable) is related to Table 2 (ProtocolTable) by the autonum
from Table 1 (ChanceryTable).

Table 2 (ProtocolTable) is related to Table 3 (CoupleTable) by the autonum
from Table 2 (ProtocolTable).

All the above relationships have the following for Join Properties:

Only include rows where the joined fields from both tables are equal.

Without "Enforce Referential Integrity" checked.

Please let me know if I'm still missing information. Thanks!

 

[Mike]

Worked like a charm!!! Thanks soo much for your assistance.