entering multiple records

[Juliet]

Hello,

I have a table "Account" with 2 primary keys, Customer ID
and Salesperson ID. Account is connected to "Customer"
table and "Salesperson" table where the Customer and
Salesperson each have a one to many relationship with
Account. I want to enter multiple Accounts per Customer.
For example on the form, a Salesperson would enter the
Customer ID and then their Salesperson ID then whatever
info is needed. However Access will not allow this. The
indexes for Customer ID and Salesperson ID in the Account
table is set to Yes Duplicates OK, but in the other
tables the indexes are set to Yes No Duplicates. How can
I have the user enter in multiple accounts for their
customers???

Thanks,
Juliet

 

[dbc]

Hello, Juliet.
The first question I would ask is, does each salesperson
try to enter the same Customer ID twice? Remember that
with a composite primary key, each Salesperson ID can be
duplicated, as can each Customer ID, but any combination
of those two values CANNOT be duplicated.

dbc

 

[Juliet]

The way I have it set up is that the Salesperson enters
his/her info in the "Salesperson" Form (ID, First & Last
Name) then they go to a "Customer" Form where they enter
all the customer info. Then the salesperson goes to
the "Account" form which is filtered from the Customer
form through Customer ID. It seems to work when you enter
multiple Accounts with the same Customer ID and different
Salesperson IDs. But this really does not make sense
because ideally that customer should have the same
Salesperson for every account (that's their contact!)they
open. Is there any way to work around this???

Thank you so much!
Juliet