Checkbox

[staholly]

I have a child table that has childtableID, ParenttableID and checkbox(yes/no). There are muliple records that have the same ParenttableID. I want to validate the checkbox to only allows one checked(yes) box per ParenttableID. Can someone help me

 

[Uncle Gizmo]

Assuming there are several check boxes marked yes, and several check boxes marked no, out of the ones marked yes, how are you going to decide which one to leave and which ones to delete?

 

[staholly]

I guess there could be multiple "no" but only one "yes". But if you have a better way of doing this please feel free to let me know your thoughts.

 

[GrahamB]

Could you not just use an option group on the form at point of entry to allow for only one selection?