Status field

[martinw]

Hi,

I want to have a field in database A (placement) that says Yes or No depending on some criterias.

If a record with the status="yes" in database B matching the clientname from the database A is found, the placement field should be Yes.

Anyone?

Thanks,

Martin

[-Queue-]

Create a relationship from database A to database B with client number as the match field. I'll call this relationship AB. (I wouldn't use client name. It is not a unique enough key.)

Does database B contain more than one of each possible client?

If not, then create a text calculation field with the following result:

Case( AB::status = "yes", "yes", "no" )

If database B may contain more than one record for each client, then sort the AB relationship (in its definition) by status [descending]. This will force related records for the client to 'float' to the top in reverse order ('n' comes before 'y' in the alphabet, so the sort must be reversed) and the text calculation will function correctly.