One last question

[north-bc]

How can I enforce/lock a table to only have one child record in another table? For example, I have a main table (tblLoad) and I only want 1 record in a child table (tbl1_Pts) that relates to the main table (tblLoad).

Any ideas?

Thanks,
Todd

 

[Ian Mac]

How can I enforce/lock a table to only have one child record in another table? For example, I have a main table (tblLoad) and I only want 1 record in a child table (tbl1_Pts) that relates to the main table (tblLoad).

Any ideas?

Thanks,
Todd

Use your primary key in the Main table as the link (which should be a given) and set the Child table MainTableID to Indexed Yes (No Duplicates)

You can then goto the relationships and when you create it 'Enforce Referential Integrity' you will see 1 to 1