We use many times long SQLs for lookups and for same field lets say product we sometimes use differendt SQL becuase we don’t remeber or we open and lookup from another app.
Suggestion: pls make “Load lookup definition” as in Manual Lookup Method and even better filter it with field name (optional)
My example for prodcut ID (I use this code on everywhere there is a product):
SELECT concat_ws(’ ‘,suppliercode,’-’, name, ‘#’ , partnumber) FROM products
WHERE ID = {product} AND active = 1 AND hidden = 0 AND company = [cid]
ORDER BY suppliercode