Hi, i want to know if is possible to load or to show or to add (i don’t know the right word) one or more records in a foundset without clear the records that are alredy present on the same foundset.
Let me explain better.
I have a formA (table view) based on tableA (detail) that shows one or more records.
From another form i perform a find on tableB (master) and i want to add the correlated records of the tableA on a foundset of the formA.
The records are alredy on the table and i want just only show these records without remove the records that are in the current foundset.
An idea of how to implement this is to take control over what is shown in form A by using controller.loadRecords(JSDataSet).
The dataset must contain the pks that you want the foundset to show.
So you create the dataset to contain the pks of the records you want shown in the form (maybe by adding the new corellated pks to a list of pks already present in the form), by query or other means then you do load and it should show only the records you want.
You could also do this in other ways; for example for formA keep a temp table or use an in-memory table created from a dataset. Any other ideas?