Relation table

[H2os]

I can not find out where access strore the information on how the relationships is set to. Like( Many to many, One to many, ect...)

I look in the Attributes but did not see any there to set it.

I what to compare to database's and check to see if the relationship information has change using vb code.

 

[Banana]

If you open relationship window, it'll tell you what relation between two tables are.

 

[Rabbie]

The relationships are stored in the System table MSysRelationships. This table is often hidden and you will need to go into Tools --> Options -->View and select System Objects to see the table.