Limit a Check Box

[lukyhare]

Does anyone know if its possible to make a yes/no check box that is limited to one?

I have a client table and a client contacts table that's related to the client table. One client can have many contacts. Im trying to see if i can put a check box field in the client contact table called main contact and was wondering if it was possible to limit the check box to only one of the contacts in the company. If another check box is clicked on then the other would disapear. Kind of like one of those "Pick Only One Of the Following" questions you get all the time. Im not sure if this is something im supposed to do in the table or in the form used for this table.

Thanks for your help.

Len

 

[KenHigg]

You could use a dlookup() to see if it existed in a before update event.

???
ken

 

[lukyhare]

KenHigg You could use a dlookup() to see if it existed in a before update event.

???
ken




Does anyone know how i can do that?
Thanks,

Len