Select only one!

[Keith]

Hi,

I have a table which contains information on my companies reps. ie.
name, car Reg, Department etc... I also have a true/false field that I
was going to use to set which rep was using the program. This all works
great except for one thing.

How can I get the system to switch so that only one rep can ever have
that fields set to true? Or is there a better way of doing this? The
idea is that the rep only set's this when they first get the program and
from then on the system knows who is using it.

 

[Keith]

It's Ok, I've worked out how to do it.

Thanks

Keith

 

[Guest]

Well, I'm gald you did but I don't know...

I have a list of clients per household. Only one can be head of household.

I have a 'Head of Household' yes/no field.

So if I add a client to the household it's possible to set Head of Household
to yes for multiple clients. Not good.

The only way I can see is using a query or macro/module to scan the Head of
Household field each time someone tries to select Head of Household and set
HofHH to false before allowing the box to check.

Wish it were easier and I still don't have the exact code in my mind...


Christian