Dynamic Sorting - across different tables

[kiwiora]

I know how to do dynamic sorting based upon a global field, but what I want to try and do, is sort on different tables by the same field. The different tables is what's throwing me.

An example:

I have a few different tables all containing a field "Name"

When the user clicks on a button to view the list, the scriptparameter chooses the correct layout/table to view i.e

LIST_[color:red][get(scriptparameter)]

[color:purple](e.g LIST_Legal)

What I want to do, is go to the appropriate list, and have it sort dynamically. I have created the same field in each table (e.g name) so what I want to do is this.

GO TO LAYOUT - LIST_[color:red][get(scriptparameter)]

SORT FIELD - [color:red][get(layoutablename)]:Name

i.e I'm trying to get away from a whole stack of

[color:purple]if get(scriptparameter) = "Legal" then sort LEGAL::Name

else if

get(scriptparameter) = "Business" then sort BUSINESS::Name

etc etc

Hope this makes sense

TIA

[bcooney]

Unfortunately, they don't let us sort by calculation. You're stuck with "hard-coded" sorts. You'll need a sort script step for each context.