Relationship issue

[OsborneBCKK]

I am fairly new to MS Access.
I have a Sales table that has several items on it from lookup tables. Like a Sales sheet that stores a Customer ID(lookup table), Sales Type ID(lookup table), Amount, Date, and 2 fields that reference the same lookup table. But when I create the relationship, Access tries to show the relationship like this.

Does this hurt anything? I'd of expected that I could reference more than one (one to many) relationships from a primary key on a lookup table.

Please help. I've got more questions that I can find answers to as well.

BRIAN

[nrgins]

A lookup table will have a relationship with one field. If the lookup table will have a relationship with a second field in the same table, then a second instance of the lookup table will be displayed in the Relationships window. So the way it's displayed is correct.