Checking another record has the same value

N

Nbene

Hi,

I am not sure how to go about this so any help or advice would be
greatly appreciated.

I have a table, tblContactOrganisation, which is a Many of a singular
tblContact.

I would like to make only one record in those records for that
specific Contact to have a true value for the field chkPrimaryAddress.

So when the user click the chk box Primary Contact it checks to see if
any other Primary Addresses have been ticked, if so it unchecks the
old Primary address and checks the new Primary address after user
acceptance.

Any advice would be greatly appreciated on how i would go about
starting this.

Cheers

NB
 
Top