Sylvain Lafontaine replied to Shay
20-Nov-09 11:28 AM
To do that graphically, you must create one or more a DIAGRAM. Insert the
tables that you want on the Diagram and you can then etablish your
relationships graphically. When inserting one or more tables onto the
Diagram, the EM should show you the existing relationships that has been
created using scripts.
Learning how to do that with a script (that you could run in the Query
Analyser for example) would also be a good idea.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)