How to account for "no related records" in a script

[Courtney]

I'm trying to write a script to loop through records in my Project table, and for each project, print a report of the related records (from a different - related - table).

How do I make my script account for the instance where no related records exist? (i.e., if no related records in table B, loop to next record in the Project table)

It doesn't seem to be an "error" per se, so I don't think the get (lasterror) function will do the trick (that was my first thought).

~Courtney

[mr_vodka]

You can check to see if a related record exists by If [ IsEmpty ( RelatedTable::PrimaryKey ) ]

[Courtney]

Thanks so much! That seems to have indeed done the trick.

~Courtney

[Steverino]

But what do you do if it's a self-join?

[Inky Phil]

I don't understand why that would need to be different.

Phil