Query - Lookup help

[catat]

Hello,

I have two tables (one is salesperson and the other is customer). When using a form, I am trying to figure out how to select one salesperson and in the next field, have a selection of customers only linked to this one salesperson (this would be through a lookup field - combo box). At the moment, I can only get ALL of the customers. I am unsure of what formulas to use within the query. I believe I do have all of the relationships set up correctly.

Thank you in advance!

[maximus]

In this sample database I have Three tables.

customers{customeID,customeName, details}
salesmanDetails{salesID, salesmanName}
products{productID, products}
salesdetails{salesentry, customerID, salesmanID, productsID}

I don't know your table structure but I assume that you want to lookup all the customers that a salesman had made sales to.

This are some entries that I have made in salesdetails

salesentryid salesmanName customerName products
1 Micheal Cynthia Deo
2 Micheal Loretta Hair Gel
4 Roger Linda Hair Gel
5 Roger June Deo

Now open look_up Form Select Salesman and Customer. Now if you select Micheal in Salesman Combo Customer Combo should show Cynthia and Loretta.

The Row Source for the Customer Combo Box is salesdetails and customers.In the criteria of cutomerId I typed the following expression.
[Forms]![lookup_form]![Combo0]

Follow this example mark the thread solved if you are able to solve your problem.

[catat]

I have yet to get it to work with my database, but it does solve my question. I was playing around in another database and I did get it to work with that one. I am beginning to think I have set up my tables incorrectly.

Thank you very much!