(1) Create an aux table with a numeric field and set the Value Display Format to be this field. (2) Add a single relational field from a primary table to this aux table. (3) Add aux table entries for the numeric field with values of 1-20
▪ Relational field values based on auxiliary tables are sorted by the table's value display format. To change the order in which values sort for the Relational field , modify the value display format for the auxiliary table.
• Relational field values based on auxiliary tables are sorted by the table's value display format. To change the order in which values sort for the Relational field , modify the value display format for the auxiliary table [page 675].
• Relational field values based on auxiliary tables are sorted by the table's value display format. To change the order in which values sort for the Relational field , modify the value display format for the auxiliary table [page 607].
The only trick with this is that you must also sort the results so the row number returned is always the same for any given row. ... select ROW_NUMBER() over( order by ts_title ASC) as TS_ID
Single relational fields to values in an auxiliary table are sorting incorrectly. If the value display format on the auxiliary table is set to <lastname>, <Firstname>
