If you have a query like “SELECT ProductID, ProductName from products” in the field {product} on a form, the value of ProductID can be referenced as {product} within the form events.
Is there a direct way to also access ProductName also? I always do a 2nd lookup within the form events but surely there is a more efficient way.
Obviously {product[0][0]} doesn’t work.