Make a lookup field display a product type from a related parent table rather than a code to which this field is physically related.
I again came across with a problem. My main register table has a field containing product_id. This is just a number which is not very informative. How can i make this field display a textual product name so that I do not see the Product)id at all, and in the main register I deal with textual Product name only. Thanks.