Newbie Question: I have a one to many relationship and need to copy a value from the Many to the One.

The one is a "project" table and the many is a "team" table. The team table contains two fields that are important. "Responsibility" and "Name".

I need to copy the "Name" value from the many into a field in the one based on a calculation of the "Responsibility". I have three fields that I am trying to copy into, "Production", "Trainer" or "Consulting". When I use a calculation, *If ( TEAM::pta.Responsibility="Production" ; TEAM::pta.contact ; "" )* and a similar calculation in the other 2 fields, I am only getting the first record in the many and it ignores the remaining records. How should I do this so that it reads all the records, and populates? Thanks

Here's my problem, I have three of these fields with IF statements. It is only copying the first value

TEAM::pta.Responsibility refers to only the first related record, as does TEAM::pta.contact. You'll need to create globals to hold each desired filter value, relationships from these globals to the Responsibility field, and value lists to hold all the related data.

See attachment for example.

ProjectTeam.zip