We are using filtered lookups on various forms to allow for custom record selection. However, one of the requirements we now have is to have a lookup that displays external Dynamics Great Plains data (ie SOP Invoices) and once the user has selected
a GP Invoice from the list we run a custom process in CRM.
Is it possible for a filtered lookup to display non-CRM data? I'm not aware of a way that FetchXML can be used to query another database, but maybe there is some approach I haven't heard of. Maybe a filtered lookup can be populated with
a query approach outside of FetchXML that supports external databases?
If this isn't possible, what would be the easiest approach to display a list of non-crm records that allows the user to select one and then have us kick off a custom JavaScript or Plugin process in CRM.
Thank you