Link to home
Start Free TrialLog in
Avatar of jandrews404

asked on

Efficient method to create a "primary contact" on a Microsoft Access 2007 form

Not sure if my title accurately describes what I'm trying to accomplish, but here's the scenario.

I have two tables - tblDeals and tblContacts with a One-to-Many relationship (one deal has many contacts)

The contacts table has a YES/NO field called "primarycontact". Currently, I have a form (tblDeals) with a datasheet subform (tblContacts). The way the application is currently set up, a user is able to select multiple "primarycontacts" in the subdatasheet by checking the checkbox. The point of the "primarycontact" field is to specify only 1 primary contact for each deal in tblDeals.

I am trying to determine the most efficient way to solve this problem. Currently, users can mark multiple contacts as the primary contact. Is there a way to only allow 1 contact in the subdatasheet to be selected? I thought about doing away with the "primarycontact" field altogether and creating a combobox on the form. The combobox would be populated with the contacts associated with the current record.

Any advice/guidance is greatly appreciated!!
Avatar of Sheils
Flag of Australia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jandrews404


sb9...thanks for the reply. I am going to try this out. Will let you know how it works.