Hi,
I have a question which i have thought and tried for a week. But still not sure if I am on the right way to do it.
The question is I need to set up an interface to select multiple productIDs, which are from a table. Once people selected 1 productID, the corresponding Description and Quantity fields are displayed. Then people go further to select other productIDs. The corresponding fields are displayed for each productID. Is it a possible way to put the productID in a combo box, display the corresponding other fields in text box; and automatically (or manually? I need select 20 productIDs at least ) produce 1 row including 1 combo box and 2 text boxes for each selection of productID.
currently i used the subform/subreport to contain the productID (combo box) and Description (text box), Quantity (text box) . The subform is filled with one same initial record for all rows. When I change either row of selection of productID the all other displayed rows changed to the newly one.
Is it possible to realize it under subform/subreport? Is it a good way for the interface?
Any suggestions are appreciated!
Fy