Extending related foundset

[Ugo]

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

[ngervasi]

Could you explain a bit better? You say "a related foundset" so I guess you have a parent record in the main form and a related foundset in a tab panel. What are you exactly trying to achieve?

[mboegem]

Hi Ugo,

I also had some trouble understanding your goal correctly.
but since the 2nd part of your post is quite a direct question:

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'

There's an equivalent of this: databaseManager.convertFoundset()
please look here for the exact syntax: http://wiki.servoy.com/display/public/DOCS/Database+Manager#DatabaseManager-convertFoundSet
The result will be a new Foundset which you can load onto your form again.

As Servoy supports much more types of objects/strings to load onto a form, there's also numerous ways to do what you want.
The above is closest to what you were used to

Hope this helps

[Ugo]

Thanks Marc, that did it.

Sorry if my attempt to clarify my needs wasn't clear enough.

I understand there are plenty of solutions available to solve the issue, as usual. Actually, applying the technique leads me to some other needs or scenarios I could think of using it.

Thanks

Ugo