Previous icon

Next icon

Finding an existing lookup table record

To find an existing lookup table entry:

  1. Right click in the field you want to find the lookup table entry for.

    A pop up menu similar to the following is displayed.

    Refresh lookup table drop-down menu

  2. Select Find Lookup Table Entry from the pop up menu.

    The Find Lookup Record window is displayed.

    Find Lookup Record - luHouse window

    In the above example you can search for a record in the luHouse table based on its Code and or Description.

  3. Type in all or part of the Code and/or Description of the lookup table entry or leave the fields blank to display all records.

    Tip: Use a % sign to do a wildcard search.

  4. Click Refresh Grid button.

    Synergetic displays all the lookup table entries that match you search criteria.

  5. Highlight the record you want.
  6. Click OK button.

    The record is selected as the entry to appear in the original field.

    House drop-down menu

Last modified: 4/10/2012 11:56:24 AM

See Also

Adding and changing entries in lookup tables

Changing a lookup table from within the field

Adding a new lookup table record

Modifying an existing lookup table record

© 2013 Synergetic Management Systems. Published 15 October 2013.

Top of page