I have 3 tables as follows:
Table 1 - item list
Table 2 - master table
Table 3 - where selected values are stored and detail table to master.
I want to Bind 8 ComboBoxes using these tables in pairs so there will be 4
pairs.
Detail table def:
masteridx
pos
value1
value2
Each ComboBox gets its list from Table1. When selected, the value goes to
Table3. value1 and value2 from Table3 are a pair of values which go to the
same record in Table3. masteridx in Table3 is the index or record id from
Table2.
Pos from Table3 is the pair of ComboBoxes to use.
I hope I made this clear enough. It's really confusing.
Thanks,
Joe