A table has 50 fields.
The database has 50 layouts.
Each layout needs upon entry to be sorted according to one of the 50 fields.
The obvious solution is to have 50 1-step sorting scripts and associate them with the 'On Entry' trigger of their respective layouts.
However, this generates clutter and increases the risk of a human mistake.
Since the name of the field can be calculated from the name of the layout, I wonder whether it is possible in a script to sorts records based on a field whose name is calculated with the Get(LayoutName)?
Thank you very much in advance.