Sorting Lists

[Jarvis]

I have a layout that sorts cabinet parts by size.

These parts are sorted first by crossgrain width.

The widest ones should show up at the top of the list.

The second sort is by length, from longest to shortest.

The list should read:

widest, (longest to shortest)

next widest (longest to shortest)

etc.

I have this layout set up to display in TABLE VIEW.

I would like to be have this re-sort occur without any additional keystrokes by me.

Is there a way for this table to automatically update and resort itself as i add parts?

Thanks for your help.

Jarvis [color:"red"]

[ESpringer]

This isn't exactly what you want (which might require scripts to run on exit field), but why not view your list of all parts through a table-view-like portal, since portal records do automatically adjust themselves when records are created and modified?

You could have a Details data entry layout on one side of the screen (or the top), and a list of all parts visible through a universal self-join portal on the rest. The relation should be able to sort by a complex set of criteria (though I can't tell your FM version; perhaps it's less easy on FM<6? I forget...)