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?
Thank you for suggestions.

Access 2003

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