When data is transferred between two tables, RapidiOnline works through the records in the order they are returned from the source database server. After reading a record from the source table, RapidiOnline will normally (depending on the functionality selected) make a lookup in the

destination table using the Table Link specified.

In some cases you can optimize performance by selecting a specific sorting. This is specifically true if you are using MS Dynamics NAV with a native database - here the sorting will be used to select a key and selecting a key that contains the fields used in the Table Link or in Delimitation is very important for MS Dynamics NAV native database.

If running on a SQL based system, the sorting will translate into an "Order By" in the select statement.

When using the Source Control feature, RapidiOnline automatically sets the sorting to the field used as Source Control and you should not specify Sorting Source Table in this case.

Field:

Here you specify the field(s), you want your data to be sorted by. If you need data sorted by more than one field, enter these on seperate lines.