Creating relationships in relationship window

[Seth]

When creating relationships in the relationship window I have been following
a rule “Always drag the bold field onto the non-bold field†(I don’t know why
someone just told me that was the way to do it).

What do I do if both my fields are bold? Does it matter which I drag on to
which?

Thanks for any help.
Seth

 

[Jeff Boyce]

Seth

When you tell Access about relationships, you are describing the Primary
Key-to-Foreign Key relationship (in a one-to-many relationship), or a
Primary Key-to-Primary Key relationship for a one-to-one relationship (not
all that common).

If I remember correctly, Access 'bolds' primary keys.

If you have two tables that both hold portions of information about the same
subject/entity, I can see you having a one-to-one relationship (both bold).
If you describe what info you're keeping in the table, the 'group would be
able to better advise you.

Good luck

Jeff Boyce
<Access MVP>

 

[peregenem]

When you tell Access about relationships, you are describing the Primary
Key-to-Foreign Key relationship (in a one-to-many relationship), or a
Primary Key-to-Primary Key relationship for a one-to-one relationship (not
all that common).

If I remember correctly, Access 'bolds' primary keys.

When creating a FOREIGN KEY, a unique constraint (index) is required
and is not limited to PRIMARY KEY constraints. IIRC when creating the
looser 'Relationship' a unique constraint isn't required at all.