One to Many Relationship Indicators

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.
 
B

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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Relationships 7
Display of relationships - one-to-many etc. 6
Table relationship design 2
Understanding Relationship Logic of Multiple Tables 2
One-to-One/One-to-Many relationship 1
Thin join line in query after establishing RI in Relationship Wind 3
Many-to-Many Relationships 4

Top