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

Inventory management database

P: n/a
I have a supplier database from the microsoft templates Inventory
management database. The trouble is when you change the supplier the
list of products in the subform remain the same everytime and are not
unique to that supplier. Is there some way to get the drop down to
display a unique list related to the supplier?

Jan 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 14 Jan 2007 09:10:46 -0800, "Phil" <da********@hotmail.comwrote:

Check out the db design: Products and Suppliers are not related. I
guess the designers thought that anyone would be able to supply
Dharamsala Tea :-)
You could add a SupplierID to the Products table, and change the query
for the Products dropdown to:
.... where SupplierID = Forms![Purchase Orders]!SupplierID

-Tom.

>I have a supplier database from the microsoft templates Inventory
management database. The trouble is when you change the supplier the
list of products in the subform remain the same everytime and are not
unique to that supplier. Is there some way to get the drop down to
display a unique list related to the supplier?
Jan 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.