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