Testing for existing related records

[Brian C]

Is there an easy way to test for the existance of related records?

Currently I create a field in the child that is a calculation = 1

I then create a calculation field in the parent that tests for the sum of the related records > 0

I would prefer only having to define a field at the parent level only if possible for a visual indicator of existing child records, and to use no fields at all if I am testing for child records in a script...

[comment]

IsEmpty ( Child::ParentID )

Or, assuming you have a serial number in the child table:

IsEmpty ( Child::ChildID )

If the ID's are numbers, and they do NOT include zero, the test can be:

If [ Child::ChildID ]

# THERE IS AT LEAST ONE RELATED RECORD

...

Else

# THERE ARE NO RELATED RECORDS

[Brian C]

Many thanks Comment, you are as always a life/time saver!

: