Hi Everyone

I am looking for an easy way to test whether a target table I am about to use in a SET RELATION TO is already engaged as a target in another SET RELATION TO ?

The Target() and Relation() functions are centred around the "parent" table. To test whether a table is a target in a relationship, using the available functions, you would literally have to loop through all open tables and use the Target() function incrementing the first parameter and testing whether the target table you seek is returned.

If this is the only way to do this, would Foxpro process this task efficiently or would it take a lot of time, relatively speaking?

TIA