G
Guest
I am in the first stages of setting up our new database. I am good at
figuring out how to tweek the old one but starting from scratch is puzzling
me.
I have only gotten as far as setting up the records in a table. What I am
wanting to do is make a drop down list in the jobs menu that only pulls up
the salepersons for that particular company.
I have tried going into lookup, selecting combo box, and then making an SQL
statement.
SELECT SalesPersons.Salesperson, Customers.CustomerID FROM Customers INNER
JOIN SalesPersons ON Customers.CustomerID = SalesPersons.CustomerID;
but this brings up all the salesperson for all companies. Can you tell me
what I am doing wrong.
figuring out how to tweek the old one but starting from scratch is puzzling
me.
I have only gotten as far as setting up the records in a table. What I am
wanting to do is make a drop down list in the jobs menu that only pulls up
the salepersons for that particular company.
I have tried going into lookup, selecting combo box, and then making an SQL
statement.
SELECT SalesPersons.Salesperson, Customers.CustomerID FROM Customers INNER
JOIN SalesPersons ON Customers.CustomerID = SalesPersons.CustomerID;
but this brings up all the salesperson for all companies. Can you tell me
what I am doing wrong.