S staholly Registered User. Local time Today, 06:39 Joined Jul 14, 2011 Messages 16 Oct 31, 2011 #1 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
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
S staholly Registered User. Local time Today, 06:39 Joined Jul 14, 2011 Messages 16 Nov 1, 2011 #2 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.
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.
G GrahamB Registered User. Local time Today, 11:39 Joined Aug 13, 2003 Messages 22 Nov 1, 2011 #3 Could you not just use an option group on the form at point of entry to allow for only one selection?
Could you not just use an option group on the form at point of entry to allow for only one selection?