I 'm trying to find if same records exists in 2 files.

I use a calc field for the relationship.

Firstname & ":" & Lastname &":" & Suffix

But it dosn't work.

I have this script :

File A

Show related records

Execute script "check existing records" : File B

Where the script def is :

If status (RecordFound) >0

Show message...

End if

It doesn't work, even if I set the first relation as a global.

I made a portal in File A to see if the relationship worked, and it does, as same records are shown in this portal if they exist, but don't appear if not

What's happening doc

I must say (may be this could help) that the records from File B (Firstname, lastname and suffix) are automatic entry fields from file A with relationship "Operator Id"::"Operator Id"...

You can use

If [ IsValid (Your relationship::The identifying field ]

Then continue as if they do exist

Else

do something here if they do not

End If.

IsValid will check the related file and if there are records that match the relationship will return a true response.

HTH and A Happy 2nd January

Thank you for that. Works best than go to related records for me. Don't know why the if function didn't work.

But yours is best than mine. Look at what I was to script :

The method I use for the moment is :

a. perform script in related file :

Show All records

Omit records

Show Omited

Omit records

b. perform script in main file

Go to related records

c. perform script in related file

If Status(CurrentFoundConts)>0

Show message "There is already a record for that..."

Sto script

End if