Change all values in column based on one selection, checkbox select only one and deselect the rest.

[behedwin]

Hey

I have a table called
Phonenumber_Table

I have a form called
Phonenumber_Form

In my table i have a column called primaryphone that have the type "yes/no".

When i set set one checkbox as YES i want all other checkboxes to be set to No.
So i can only have one phonenumber that is marked as YES.

My form is continuous.
My table also contain a secondary key that have a one to many relationship to a table with names.
So each name can have several phonenumbers. So the end result is to get one phonenumber per name that is "primary phonenumber".


How is this done?