Drop down list

S

Sonny

I want to create two drop down boxes that are depending on each other.
For example I have a datasheet with fields like (customers,date,SKUs). I
want to be able to create a drop down list based on Customer Name and another
drop down based on SKU's. If I choose Customer A, the second drop down only
allows the SKU's for that customer and vice versa, If I select a SKU, I only
want Customers with that SKU in the other drop down list.

Any help will be appreciated.

Thanks in advance!
 
Top