stressedbrian
New member
- Local time
- Today, 14:55
- Joined
- Apr 20, 2011
- Messages
- 7
Hello folks,
I have created a new form and within this I have created a drop down combo box from a small table (sep to the main table).
First it was updating the main table with the i.d number of the small table field rather than the field in the combo box, I sorted this by making the combo box from the main table setup using the lookup wizard.
On this wizard I selected multivalue which is great and that work and all updates.
However when I look at a record in my form view and update the multivalue box, it seems to duplicate the record by however many multivalues I have put in. By this I mean I have to click several times past duplications of the record I am on to get to the next different customer record (annoying if you want to click to the next record and phone a new customer!)
It is not duplicated in the main table, why would this happen?
cheers
I have created a new form and within this I have created a drop down combo box from a small table (sep to the main table).
First it was updating the main table with the i.d number of the small table field rather than the field in the combo box, I sorted this by making the combo box from the main table setup using the lookup wizard.
On this wizard I selected multivalue which is great and that work and all updates.
However when I look at a record in my form view and update the multivalue box, it seems to duplicate the record by however many multivalues I have put in. By this I mean I have to click several times past duplications of the record I am on to get to the next different customer record (annoying if you want to click to the next record and phone a new customer!)
It is not duplicated in the main table, why would this happen?
cheers
