How to create a LOV from select statement

Hi @SarahS ,

Please note the IFS application version this question is in reference to. 

Thanks,

Kasun

If you don’t mind being restricted to the identities you’ve done business with, the IDENITY_INVOICE_INFO table contains both entities and could be used as part of a join to both the customer and supplier tables.

Otherwise you would need to establish a UNION query (which I’m not sure will work directly as an enumeration).