I have two databases, USER and CPU, related to each other using a field called CPUID.

Here's the basic setup. USER database holds user info(last name, first name, etc.) while CPU databse holds cpu info(Model, speed, etc.). Each CPU record has a unique number which is stored in CPUID field. This is good and works fine. In the USER db I also created a CPUID field which I'm using to connect a user record to a cpu record. So the relationship is from CPUID to CPUID both ways.

From the USER db, I go to the user record I want, then enter the unique number for the cpu record I want in the CPUID field, bringing up the information for the related record. In this way I assign a computer to a user. I hope this makes sense, I strugle with db terminology.

Here's my issue. I want to restrict the ability to assign any CPU record(CPUID number) to more then one USER record. Meaning, two users cannot have the same cpu.

is there any way to have fmp check to see if the number I'm entering in CPUID(which is a related field) have been entered before in the users db?

I hoep that makes sense. .if it doesnt pleae diect we where to clarify.

Thanks in advance,

Steve S

Use a conditional value list or have a look to that thread

Click here

You could also do a verification that checks to make sure the data is unique. ITs a simple checkbox. Then, it'll just yell at you if you enter a non-unique code.