Case Function Between two Tables

[NuttyMoose]

My Tables:

Main

Policies

Relationship

MainID --> Rel_MainID

Note: There can be many policies per main page

Fields:

Ins_Status - radio buttons (In House Review, Closed)

Policy_Status - Active and Closed

Is there a way to have a case fuction work between two different tables. I would like a case fucnction to do this. Here is an example: When In House review is selected on the main page I would like the policy_status to change to Active and when closed is selected i would like policy_status to say Closed.

I have tried this: for the field Policy_Status

Case(

Main::Ins_Status = "In House Review", "Active,

Main::Ins_Status = "Closed", "Closed")

But this does not work?

Brahim

[QuinTech]

Hi Brahim, what you've posted looks like it should work. Are you sure the relationship is valid? Test it by creating another field =IsEmpty ( Main::Ins_Status ).

What is returned by this calculation that you do not expect?

Jerry

[Damocles]

If the case statement is a cut&paste from your field definition, there's a " missing from after the second "active" in the Case statement.

It looks like you need for your relationship to go the other way....

MainID <-- Rel_MainID

As it is, are the records in "policies" able to determine which records are related? Maybe I just need more caffeine.

Paul