If you sort the list by RowID alphabetically, then you are going to get random results because rowid is a random generated value.
Using the array for the relation will not guarantee the sort order of the list. The sort order of the list is determined only by the values in the exercise sheet.
If you are saying that an exercise could be either the 1st position or the 5th position and you want to respect the order they were entered in the workout, the I would create a relation for each ‘ex’ column and create an inline list for each relation.
Thank You Jeff.
Here is what I did as you suggested with a small twist.
Created 8 Workout->Exercise relations for each of EX1 to EX8 attributes. Even though EX1 in Workout has a 1:1 relation with Exercise, I had to indicate 1:many to enable INLIST component to see it.
Now I can maintain the desired order with a bit of extra work.