Extender Lookup against a view
We are at GP 2010 using Extender Enterprise. Has anyone figured out a way to have a Lookup that uses a database view or goes against more than one table? CSM Service Orders are moved out of the active table into a history table when they are completed. I have an Extender Window that needs to be able to look up open and closed Service Orders for an "Originating Service Order" field. I haven't figured out a way around this other than to not validate the field and make the users type in the 15-char service order number every time which would not make them happy. Any help is appreciated.
If you would like to submit an answer or comment, please sign in to the eOne portal.