adding a record and sorting the foundset

Maybe logical but an annoying issue! to me…

When I add a record the record is attached to the end of a foundset. Makes sense.

Now, I normally sort the list that shows the foundset and that foundset is sorted in another way than by record index.

After adding the record and doing the sort the last record is selected but this is not the new record anymore…

This makes no sense to the user (neither) to me. So I leave out the sort but now the issue is that the (sorting-) order is broken… This also makes no sense.

How can I overcome this?

Hi Marcel,

Are you displaying the results in a tabpanel/listview?

Bob Cusick

I have a form ‘orders’ from which I create the new record.

On that form there is a tabpanel with a list(view) of all orders in this foundset (the same as the form orders itself)…

IT2BE:
After adding the record and doing the sort the last record is selected but this is not the new record anymore…

This is something I do not understand, Servoy did select nothing, it will reselect the row after a sort in Servoy 2.0 rc12 (if new row is still present within pk chunk)