Skip to content


Populate Field in Extender Form with data from SQL Table in another SQL Database

Lisa Sorensen asked 8 years ago
Is it possible to populate a field in an Extender form (Not Extender Enterprise version) with data from a SQL table in another SQL Database? (i.e. There is a list of Carriers stored in a table/view in a different SQL Database. We would like to have a lookup field that is available in an Extender form to allow a user to select an existing Carrier and associate it to an Item Number in GP) . Is this possible using the Standard Extender forms?
Lorren Zemke Staff answered 8 years ago
It is not possible to pull data from a non-GP database. The Lookups within Extender pull from existing Dynamics GP products installed on the system. With Extender Enterprise you would be able to write Dexterity code to get the data from another database and use it for validate for data entry
james replied 6 years ago

New to this. Can an Extender Window lookup data from another Extender table? I’d like to create a lookup table and reference it from another Extender Window. Thanks

Lorren Zemke Staff replied 6 years ago

James, If you create an Extender Form, that form will be available as an option when you use the Lookup Data Type in another extender window or form.

If you would like to submit an answer or comment, please sign in to the eOne portal.