I have a table of items in Access that has a ProductId (dropdown) and other fields. I would like to automatically display the price, description and deminsion fields when the ProductId is chosen from the dropdown. Can anybody help?
I had a similar type of need in one of my projects. I addressed it by using additional lookup boxes that I made 'dependant' on the Product lookup box. I set up tables with a product column and a size column, a table with a product column and color column, a table with a product column and a description column, etc... In my table, if I only enter one size, color, description, for each product, that comes up as a default. If there are more, when a user selects that product, they have the option to choose the features they want.