Using Lookup

The Lookup function allows you to choose criteria from a pick list and to enter text. You need a minimum of one search parameter for the query to display results. You can narrow your search by including more conditions. You can also save a lookup as a group.

To perform a lookup

  1. Do one of the following:
    • Open the Detail or List view for the type of record you want to look up and click the LookupClosed tab. (For example, Contact)
    • In the Navbar, right-click the type of record you want to look up and click Lookup.... For example Lookup Accounts...
  2. In the Lookup by box, select a search condition from the drop-down list.

    The Lookup by options depend on the columns included in the layout of the lookup, which are determined by the group you selected as the Default Lookup Layout in your Group options. To include another search item in the list, you must either update the Default Lookup Layout group to include the column you wish to search by, or change the Default Lookup Layout to a group that includes that column in the layout.

  3. Select a search condition operator from the drop-down list. For example, Contains or Starting with.
  4. In the next box, type your search criteria according to the search condition you selected.
    For example, if you are looking for the account named Abbott Ltd, you would type "ab" in this box.
  5. To add another search criteria, click the Add ConditionClosed button and repeat steps 2-4 for each search criteria you add.
  6. When you have entered all of your search requirements, click Search.
    The records that match your criteria display in the Lookup Results tab

All searches are run on the records you can access. Depending on the options chosen by your administrator, you may also be able to find records based on the group to which it belongs.



What's New in this Release


For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at