Hi:
I have a table and a form with Part Number and Part Description. Right now, I have the form set to autofill the part number and price when a particular description is selected, and autofill the description and price when the part number is selected (using combo boxes). My customer now wants to add a "Manufacturer" field to the database. Is it possible to design the form so when a manufacturer is selected, the combo box only shows the part (numbers and descriptions) that are available for that manufacturer?
Thanks for your help!
Miranda
I have a table and a form with Part Number and Part Description. Right now, I have the form set to autofill the part number and price when a particular description is selected, and autofill the description and price when the part number is selected (using combo boxes). My customer now wants to add a "Manufacturer" field to the database. Is it possible to design the form so when a manufacturer is selected, the combo box only shows the part (numbers and descriptions) that are available for that manufacturer?
Thanks for your help!
Miranda