Gossamer Forum
Home : General : Databases and SQL :

access relations

Quote Reply
access relations
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.
Quote Reply
Re: [donbes] access relations In reply to
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!