By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,399 Members | 1,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,399 IT Pros & Developers. It's quick & easy.

Look Up

P: n/a
I have created a list of products from suppliers. I have also created a
subform where the user can select the products they want. The main
problem is this list in the subform (combo box) has every product from
every supplier. I want the list to be unique to the supplier, so only
the products in the drop down are from that supplier. The supplier is
selected form the main form first and then in the subform the user
selects the prodct.

Dec 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Assumund the product table is something like
ProductID Autonumber
ProductDescription Text
SupplierID Numner (Long Integer)

All you need to do is ensure that the LinkMasterFields and LinkChildFields
in the subform both say SupplierID

Phil
"John" <da********@hotmail.comwrote in message
news:11**********************@t46g2000cwa.googlegr oups.com...
>I have created a list of products from suppliers. I have also created a
subform where the user can select the products they want. The main
problem is this list in the subform (combo box) has every product from
every supplier. I want the list to be unique to the supplier, so only
the products in the drop down are from that supplier. The supplier is
selected form the main form first and then in the subform the user
selects the prodct.

Dec 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.