TheTrainMan
Registered User.
- Local time
- Today, 22:00
- Joined
- Dec 11, 2002
- Messages
- 18
I need to compare the two sets of values to see if they match. The user enters the first set in a form and this is saved in a table. The second set of values I want to create by selecting one value, and returning all related values (as stored in a separate table).
i.e. the first set of data might be
orange
apple
pair
beef
chicken
lamb
circle
square
triangle
The user enters this into the form as above. the second set of values is a check on the first, so the output (if everything is good) would be the same as above, but I want to select from a combo box that only holds the values fruit, meat and shape. I also want to compare the two lists to see if they match and if not, I need to know what's missing.
Basically I want to use one combo box to generate multiple data (if I select fruit then ALL orange, apple and pair are seleceted) either in a table or somewhere else. I can fill one text box (and hence table field) using a como box, but how do I do it when there are multiple entries for each possibility in the combo box?
i.e. the first set of data might be
orange
apple
pair
beef
chicken
lamb
circle
square
triangle
The user enters this into the form as above. the second set of values is a check on the first, so the output (if everything is good) would be the same as above, but I want to select from a combo box that only holds the values fruit, meat and shape. I also want to compare the two lists to see if they match and if not, I need to know what's missing.
Basically I want to use one combo box to generate multiple data (if I select fruit then ALL orange, apple and pair are seleceted) either in a table or somewhere else. I can fill one text box (and hence table field) using a como box, but how do I do it when there are multiple entries for each possibility in the combo box?
