I have 3 tables.
1st table SALESOURCE-TYPE showing the types of sales retail, wholesale, advertising
2nd table is the names of our customers and what type of sale it is either retail, wholesale or Advertising
Now, i want to create a repeating group based on SalesourceType priority of the order’s Salesource name.
So the table 3 (red) should be looking after sorting as
I can create a new filed inside table ORDER-TABLE and record the salesourcetypepriority when the order is received. However is there a way of obtaining the SalecourceTypePriority of the SalesourceName on table 3 and use it for sorting the repeating group?