Relationship Question

[Joe Williams]

I noticed that in a FE/BE scenario, you can set relationships in both the FE
and the BE and they are maintained independently.

Which end is the proper end to create the relationships between tables? If I
set them in the BE, does the FE know about them?

Thanks

Joe

 

[Armen Stein]

I noticed that in a FE/BE scenario, you can set relationships in both the FE
and the BE and they are maintained independently.

Which end is the proper end to create the relationships between tables? If I
set them in the BE, does the FE know about them?

Thanks

Joe

Hi Joe,

Keep the relationships set in the back-end database. They will be
enforced whether being used directly or via linked tables in the front-
end.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com