Scan Rank

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