Inventory management database

[Phil]

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?

[Tom van Stiphout]

Re: Inventory management database

On 14 Jan 2007 09:10:46 -0800, "Phil" <david_lcfc@hot mail.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?