One to Many Relationship Indicators

[ploddinggaltn]

I don't understand why in my relationship window the lines connecting my
tables don't show the 1 and 00 at the end of the lines to designate 1 to
Many. When I right click on the line, the diolog box says 1 to Many. Do I
need to correct a property or option to show the 1 and 00. Any help you can
give me is very much appreciated. Thank you.

 

[Jeff Boyce]

"Show" it where?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BURL ives]

Hey........maybe I can help....

right click on the line and select EDIT RELATIONSHIP.......click on
the option to ENFORCE REFERENTIAL INTEGRITY......

I believe that you need to be sure the field on the ONE side is a true
PRIMARY KEY (no duplicates and REQUIRED)....the FOREIGN KEY should be
the same data type as the PRIMARY KEY.

I think it should work.

Burl !