G
gls858
I have a data base that isn't really working the way I would like
and I think it's due to a design flaw. After reading here
I'm pretty sure it needs to be redone. It pretty simple. We use this
database to track which customers get Christmas cards. I have a
list of customers and a list of employees. Each employee submits
a list of the customers they wish to receive a card. the problem is
that many of us have contact with the same customers. So one customer
might appear on multiple lists. I need to be able to create a list
for each employee to review but also create a list with no duplicates
to mail the cards.
Am I right in assuming that this is a many to many relationship?
I have an Employee table and a customer table but from what I've
read here I need a third table if this is a many to many relationship.
I'm not sure what needs to be in this 3rd table.
The customer table has a primary key that is an autonumber and the
employee table has a primary key that is a EmpID that is a number.
If I under stand correctly these two fields need to make up the
primary key on the third table. Is this correct?
I'm not sure what do from here.
gls858
and I think it's due to a design flaw. After reading here
I'm pretty sure it needs to be redone. It pretty simple. We use this
database to track which customers get Christmas cards. I have a
list of customers and a list of employees. Each employee submits
a list of the customers they wish to receive a card. the problem is
that many of us have contact with the same customers. So one customer
might appear on multiple lists. I need to be able to create a list
for each employee to review but also create a list with no duplicates
to mail the cards.
Am I right in assuming that this is a many to many relationship?
I have an Employee table and a customer table but from what I've
read here I need a third table if this is a many to many relationship.
I'm not sure what needs to be in this 3rd table.
The customer table has a primary key that is an autonumber and the
employee table has a primary key that is a EmpID that is a number.
If I under stand correctly these two fields need to make up the
primary key on the third table. Is this correct?
I'm not sure what do from here.
gls858