I have a form frmNewEnterAddress, that populates tblAddresses with a yes/no field called DefaultAddress. How do i restrict the addition of further address records, with the same ContactID, from being able to select 'yes' when that ContactID already has a record with a default address set to 'yes'.
I have a combo box lookup for "ContactName" frm tblContacts, and though it's likely that all contacts already have a 'DefaultAddress', some may not. I thought some procedure on the selection of the combobox contactiD could trigger an event, such as making the yes/no control unavailable (don't know the term) and maybe a msg "This contact already has a default address, do you wish to change it to this new address" then what ever needs to happen in either case.. would appreciate any other suggestions - also, really don't know how to approach writing the procedure other than thinking it starts with and IF statement
Thanks for your time..