2 Combo Boxes bound to one Same Data Source

[dstrain]

I have 2 combo boxes on a form that are both bound to the same data source. The combo boxes are labeled Contact 1 and Contact 2. I have a table full of contacts and a project data table but I may have more than one contact for a project. When I enter a value for the second combo box, the first combo changes to that value. If I go back and change the first combo then second one changes to that value. How can I get it so the combo boxes can have their own value even though they are coming from the same data source?

 

[boblarson]

When a field is in the table, it is ONE field. Binding two controls to the same field does not change the fact that it is still one field. So, if you change one control, the value will change. And vice-versa.

If you have more than one contact, then you should be storing that information in a separate junction table to handle the one-to-many relationships. That would require the use of a subform.