Omit records with an empty field

[Jason Goldsmith]

I'm trying to create a script to search a field in a related file, copy the latest entry into that field and bring it back to the master file. Seems simple enough with the 'go to last record' command. However, some of the records in the related file have no data entered into the field of interest. I would like to omit those records with empty fields before going to the last record? How do I accomplish this?

Thanks in advance!

[Ugo DI LUCA]

If this script is to be performed frequently, you could have a boolean indexed calculation in the related file c_MatchNotEmpties = Case(Is empty(your field),0,1).

Then establish a new relationship from a global (number populated with 1) in the Main file and the c_MatchNotEmpties.

A script :

Go To Related Record (The new relationship - show)

Perform External Script (Set Last value)

-----Go To Last record

-----Set Field (g_field, your field)

Set field (your field, ::Related:g_field)