Hello,
I have a table with multiple accounts. Each can have a parent record in this same table.
How one would extend the current foundset so that it now extend to the parent records. Is there any native function that would help or should I go SQL on this ?
Basically, asthe context stays into the same table, I suppose I could do a find/search on any non empty parent key on a newRecord(), what I am looking is the equivalent of the FileMaker script 'Go to Related Record' with an option 'match all records in the current found set'
Thanks
Ugo