Hi,

I've been reading and reading but can't seem to find my answer. Perhaps I am going about this all the wrong way too!? I have a db with persennel records. Within it I have a portal to a training records db (there could be hundreds of training records per person) I get them to list just fine. Now I need field that shows if a person meets certain requirements by having, say, 4 specific trainings. I'd just like a "YES" or "NO" in the field. I tried the If function and it only looks at the first record in the portal.

Perhaps I am going about this all wrong and there is a much easier way? Please, any help would be greatly apreciated.

Thank you!

You are probably going to need one relationship for each of the training record types you wish to test for. For example.

Create a key field in the training file:

kPersonIDTrainType (calculation, text, indexed) = PersonID & Training Type

also create

iOne(calculation, number ) = 1

Create four keys in the Personnel File:

kKey1 = PersonID & "writing" (I have no idea what types of training you have!)

kKey2 = PersonID & "reading"

kKey3 = PersonID & "arithmetic"

kKey4 = PersonID & "spelling"

Create four relationships from the Personnel File to the Training File:

Rel1 kKey1 <--> kPersonIDTrainType

Rel2 kKey2 <--> kPersonIDTrainType

Rel3 kKey3 <--> kPersonIDTrainType

Rel4 kKey4 <--> kPersonIDTrainType

Now to put it all together:

Training Flag (calculation, number) = Rel1::iOne and Rel2::iOne and Rel3::iOne and Rel4::iOne

This flag field is only true (a one) if all four types of training records exist at least once in the Training File. Using number formatting options the field can be set to display "Yes" for one (true) and "No" for zero (false).

-bd

Okay, WOW. This is a db for a fire department. There are a ton of training requirements and all are different for different positions. ie: chief, EMS officer, etc.

I am going to attempt what you wrote. I think I get the concept. I'll try it with a sample.

Thank you so much!