Getting a related table's data

[the_kid]

Hi,

I have two tables with related "department" fields:

Awards (table)

Department (text field)

Person (text field)

Grant_Contract (text field)

Department (table)

Department (text field)

Contract_Person (text field)

Grant_Person (text field)

If the Departments are the same in both tables I'd like to pull in the appropriate person from the Department table based on the data contained in the Awards::Grant_Contract field.

Example: If the Awards::Grant_Contract field = "Grant" then the Awards::Person field = Department::Grant_Person field.

I've tried this caluculation for the Person field in the Awards table:

Case ( grant_contract = "grant" ; GetField ( "department::Grant_Person" ); grant_contract = "contract" ; GetField ("department::Contract_Person"))

But it's not working... Any help is greatly appreciated.

[the_kid]

Cheese and crakers! I figured it out and it was too simple. The calculation should be:

Case ( grant_contract = "grant" ; department::grant_person ; grant_contract = "contract" ; department::contract_person )

My apologies for posting needlessly.