Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

How to create a Microsoft Great Plains Extender Lookup


INTRODUCTION

In Microsoft Business Solutions - Great Plains, you can create a Microsoft Great Plains Extender Lookup so that a user can open a Microsoft Great Plains Lookup from an Extender Window. If you have clicked Lookup in the Field Type list in the Extender Window, you can select the Extender Lookup that you created. This lookup does not have to be the same form that is used for the Extender Window.

↑ Back to the top


MORE INFORMATION

For example, you create an Extender Lookup that is based on the Account Master table. This lookup can be accessed by an Extender Window that is based on the Item Quantities Maintenance form.

The following steps describe an example of an Extender Lookup. This example will create an Extender Lookup that accesses the Account Master table. The Extender Lookup will display the Account Description data and return the value to a field.

The following steps refer to Fabrikam, Inc. Fabrikam is the fictitious company that is used for demonstration purposes in Microsoft Great Plains.
1. On the Tools menu, click Extender , and then click Extender .
2. In the Extender dialog box, click Lookups , and then click New .
3.

In the Extender Lookup Maintenance dialog box, specify the following settings:

Lookup ID : Account Description
Description : Account Description Lookup
Product : Great Plains
Series : Financial
Table : Account Master
ID Field : Account Description
Description Field : Account Description



     
4. Click Save .

Now you can access the Account Description Lookup from another Extender Object when Lookup is selected in the Field Type list. The Account Description Lookup will display the Account Description data.

↑ Back to the top


Article Info
Article ID : 908701
Revision : 1
Created on : 3/6/2017
Published on : 3/6/2017
Exists online : False
Views : 98