If "Yes" then all others "No"

[Guest]

I'm not sure how to design this. I have a table with these 3 pertinent fields:

tblPKFMsMaterialLayers
txtProfileID (PK)
txtLayer (PK)
txtFoodContact

This table is for many in a one-to-many relationship with tblPKFMAttributes.

txtFoodContact is set to True and its values are "Yes" and "No". Only one
txtLayer record can be "Yes" and all others must be "No" for any related
record in tblPKFMAttributes.

How can I set this up? As it stands I can select "Yes" for all txtLayer
records for a related record in tblPKFMAttributes.

Thanks for your help!

 

[Perry]

not considering possible enhancement(s) to yr datamodell, you have to
keep a strict validation concept in yr interface ensuring that one record
for txtLayer can be set to True in tblPKFMAttributes.

No info on yr forms, so can't advise on how to enforce the abovementioned
validation.

Krgrds,
Perry