how can i create a LOV that combine both suppliers and customers ? or how can i populate an enumeration using select statement ?
+20Hi
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).
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.