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?
Answers
Lorren Zemke Staff answered 8 years ago
Lisa,
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
Lorren
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
Lorren
james replied 6 years ago Hi,
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.