Table Relationships

[CEV]

I just noticed that when I look at the relationships window in my Front-end
and then look at the one in my Back-end, they do not match. I do not know
how this happened or even how it should be. Should the relationships be
setup in the front-end or the back-end? I would think it would be the
back-end. Would I then delete the relationships in the front-end?

Thanks,

CEV

 

[mscertified]

If your tables are in the back end, set up the relationships there.
I would delete whatever relationships are there and start over.

Dorian

 

[Pat Hartman\(MVP\)]

Relationships are defined in the back end since that is the only place you
will be able to enforce referential integrity. You should be able to see
them from the front end but you may need to manually add the tables to the
relationship window. Once two related tables are added, the links should
show automatically.

Whether the relationships show or don't show in the fe is immaterial. As
long as they are properly defined in the be, Jet will enforce them wherever
the tables are used.

 

[CEV]

Very good explanation!!

Thank You,

CEV

Relationships are defined in the back end since that is the only place you
will be able to enforce referential integrity. You should be able to see
them from the front end but you may need to manually add the tables to the
relationship window. Once two related tables are added, the links should
show automatically.

Whether the relationships show or don't show in the fe is immaterial. As
long as they are properly defined in the be, Jet will enforce them
wherever the tables are used.