Creating relationships in relationship window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seth - 21 Jul 2005 00:47 GMT

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

Reply to this Message

Jeff Boyce - 21 Jul 2005 02:34 GMT

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>

> 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
[quoted text clipped - 5 lines]
> Thanks for any help.
> Seth

Reply to this Message

peregenem@jetemail.net - 21 Jul 2005 14:58 GMT

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

Reply to this Message