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

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

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

~Courtney

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

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

Phil