Relationships

[T.J.]

Can you please tell me the operational model of
relationships in Microsoft Access? What does it really
do? Does it create a separate table where it holds the
relationships or something?

Thanks,
T.J.

 

[James Goodman]

Yes, see MSysRelationships. It is a system table, so you will need to make
sure you have enabled the option to show then...

 

[JohnFol]

I think t.j. is after the effect of defining the relationship, ie does it
enforece RI, does it improve performance etc .. .