Rank records in the foreign table for each of their corresponding primary table entries - according to the value in the rank field.
Same values will have the same rank unless Always Increment is selected.
Choose Ascending for the lowest value to have rank 1
