When one creates a relationship between two tables in the same datadase, what is the test that it works. I created a relationship, but I seem to be stuck.
Nov 24, 2002, 7:27 PM
Veteran (17240 posts)
Nov 24, 2002, 7:27 PM
Post #2 of 2
Views: 3603
Well, you could do one or more of the following:
1) Right click on the table and the relation line connector between the two tables in the "Relationship" manager/editor. If you see that the PRIMARY and FOREIGN KEYS match, then the relationship is there.
2) Try inserting data into the child table and see what error you get if you try to add a record that does not contain a PK in the parent table.
========================================
Buh Bye!
Cheers,
Me
1) Right click on the table and the relation line connector between the two tables in the "Relationship" manager/editor. If you see that the PRIMARY and FOREIGN KEYS match, then the relationship is there.
2) Try inserting data into the child table and see what error you get if you try to add a record that does not contain a PK in the parent table.
========================================
Buh Bye!
Cheers,
Me