Best way to check if there are related records?

[deego55]

I have a script that checks field validations in a portal from a related table.

The script needs to check if there are not any related records, so it can skip the validation checks if this is the case

I had been using a 'Go To Related Record' script step and checking the LastError result to see if there are not any related records.

Is there a more standard way or stable way? Perhaps a field in the master table with a RecordCount of related recs?

[LaRetta]

Begin your script with:

If [ IsEmpty ( relatedTable::keyField ]

... do whatever because no related records exist

Else

... do whatever because you have related records

EndIf

Replace 'relatedTable::keyField' with your true relationship name and whatever field is the join key between the tables.

[deego55]

ah yes...the obvious! thanks LaRetta!