jaworski_m wrote:
Hello,
Suppose there's a table (many side):

ID (PK)
ID_foreign (FK)
field 1
field 2
yes/no field

How can I allow ONLY ONE record to have "yes/no field" = True? (with table
validation rule)
In case a user sets a second record "yes/no field" = True an error is
triggered.

What happens when you add a unique index (no duplicates) to the yes/no field?
You do realize that with this rule enforced at table level, you can only have
two records in your table, right? (one Yes and one No).
Thank you for suggestions.

Access 2003

--
Message posted via http://www.accessmonster.com