Unique field value

[rick fry]

I have a 2 field database field 1 is a text field field 2 is a yes no check box. I only want one record to have yes selected. Therefor if someone click on yes when another record has the value set to yes, the action of clicking yes on the subsequent field changes the value in the intial record.

[comment]

This doesn't seem like a good idea. You should write the selected record's unique ID to some location (it's difficult to be specific without a better description, but a global field would be a good choice in most cases).

[Lee Smith]

Attach a copy of your database (striped of any confidential data) or make a mock up that demostrates what you are asking.

Lee

[LaRetta]

But what if two Users click yes in two different records? Which User would take priority? I think it might help to understand what this table represents and most certainly, what the Yes represents. Understanding the purpose and context will help us give you a good answer. :wink2:

[LaRetta]

Wow ... 3 responses! Does this forum rock or what? BTW, I hadn't seen the prior two when I responded. :laugh2:

[Raybaudi]

Hi rick

I only want one record to have yes selected.

you can try this.

( it works w/o loosing the found set but still having only one yes in all records of the DB )

Only_One_Yes.zip

[LaRetta]

We didn't suggest this method because it will break in multi-user mode. There isn't even error trap on this script ...