One to Many Relationship Indicators

  • Thread starter Thread starter ploddinggaltn
  • Start date Start date
P

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.
 
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 !
 
Back
Top