Continuous Forms

[marcuscoker]

Hi Was wondering if anybody could help me with this. I have a Continuos form with a each record havin a checkbox. I would like to find a way that only one of those checkboxes can be ticked on the form at any one time.

Thanks

Marcus

 

[Dennisk]

Place some validation in the before update event of the tick box.
This will be an SQL statement that counts the number of 'ticks'.
Is it one tick per table or one tick for a group of Foreign Keys?

 

[marcuscoker]

thanks will try that, i just wanted it to be one tick for whole table