I have a form with a select list which gets it's data from a table called Products. Table Products has two fields, Product_ID and Product_Name. The list is set to display column 2 (Product_Name). I have an invisible text box on the form being populated with column 1 (Product_ID).
I also have a table called Products_To_List which two fields, Product_ID and Text_Box_Name.
Now, what I need to do is show a number of text boxes below this select, the quantity of which will be dependent upon which Product_Name they have selected. I need to look through table Products_To_List and find all the Text_Box_Name entries which have the ID for Product_ID, and show only those text boxes, with the visible title of the text box populated by the Text_Box_Name. I also need to be able to allow the user to update fields in another table, Product_Info, by typing into the text boxes that appear.
I hope this makes sense. Thanks for any help.