Is it possible to validate the value of two records in a multi-record file?

I use the field for a valuelist in other files. The selections in the other files trigger calculations results. The calculations have two of the record values defined predefined in their calculations.

I have tried the ValueListItems( ) functions but it seems to calculate after the validation calculations.

Thanks.

Hi Mark, you could probably do this with two relationships and a script.

Make a field in your multi-record file called "Flag". For the first record, set this field to 1; for the second record, set it to 2. Now in the file from which you want to do validation, make two globals. Set the first to 1, and set the second to 2. Make a relationship from the first to the foreign field Flag and call this relationship Rel1. Make a relationship from the second to the foreign field Flag and call this relationship Rel2.

Now use a script to validate: The script steps will be

If ( Rel1::SomeField = "Whatever you want")

If ( Rel2::SomeField = "Whatever else")

<your code here>

Else

Exit Script

End If

Else

Exit Script

End If

Does this help?

Jerry

Yes, that was my second thought aswell.

In the end I think I'll define a calcualation field as...

"Value 1" & "