Lookup Table Maintenance Program

Lookup Tables are maintained using the lookup table maintenance program, Lookups.exe. The contents of a system lookup table are provided by AFS and may not be changed. The contents of custom lookup tables may be changed by the AFS administrator at your site.

To view the contents of a lookup table, select a row in the top grid.  The contents of that table are displayed in the bottom grid.  To change the order in which the items are displayed in Lookups, click on the title of a column in the bottom grid. Clicking on a column title does NOT change the order in which items are displayed in afs:TRADE (see below).

To update Custom Lookup Table entries, select Custom and click the row in the Lookup Table List grid for the table you wish to edit. This will populate the Lookup Table Values grid with the current set of entries for the selected table.

Use the arrow buttons to change the order of the selected row. Use the + and - buttons (or Insert and Delete on the keyboard) to add and remove items. Use the print button to print a report on the selected table. Use the Print all button to print all lookups (see not below on printer notification).  Use the reorder button (icon with the yellow hand) to reset the display index for all items using the current order in the grid.

To change the lookup table to that it display in alphabetical order, by code, in afs:TRADE, click on the Code column to reorder the display in Lookups, then click the reorder button to reset the Display Order using current order.

See also

• When using the Print all button, if printer notification is turned on, you will receive a notification message for each lookup printed.  See http://support.microsoft.com/support/kb/articles/q122/1/60.asp for information on disabling printer notification.