Is there a way to create a multi-column Ref dropdown?
I have an Inventory list for which I want to apply Custom Pricing.
While creating entries in my Custom Price table,
I am displaying the Products by their Description.
The Product Ref drop down allows for searching but only with the displayed Description column.
I would like to be able to also find a Product for the new Custom Price entry by its Product Code (the Key) or by a scanned UPC code.
Is there some way to achieve this is a single Ref dropdown list during the creation of the new Custom Price entry??