Sorting The Badge Order

The initial badge order is by employee number in the sample database.  We will experiment by changing the order to employee name by doing the following:

1.  Click on the tool bar Sort Database button, a dialog will appear

2.  Click on the pull-down box against EmployeeName and change the value to 1

Before you click OK let us see what the dialog box is telling us.  Assuming you have not previously changed the sort order for this database, the sort order will be first by EmployeeName because the pull-down box is set to 1.  The other pull-down boxes changed during step 2 above to allow this to happen.  In the unlikely event of two employees with the same name, their badges will be sorted by their badge number.  In the equally unlikely event of them both having the same badge number, their badges will be sorted by department.  Following this logic to its conclusion, the subsequent levels of sort are EmployeeNumber, Datakey, PhotoFile, Template and Changed.  If the order is not as described here, press the dialog Reset button and repeat steps 1 and 2 above.  Feel free to experiment by changing other field sort numbers to see how this dialog works.  If you wish to exclude one or more fields from the sort order, set the pull-down entry for the field to "-".

Finally the column of squares with “Rev” against them allow you to reverse the sort order.  If you click on the check box in the EmployeeName row an “X” will appear indicating that the sort order will be reversed.

When you have finished experimenting make sure that the EmployeeName pull-down is set to 1.  Because each employee has a unique name the settings in the other columns do not matter.  Also make sure that the sort order is not reversed.  Click on the OK button.

Use the arrow buttons in the tool bar to confirm that you have the expected sort order.