For example, consider a table purchase_order with a lookup to an address table.
The link is made to the PK field of the address table.
In the purchase order screen, I want to be able to show fields of the address as separate fields.
I know it is possible to work with expression fields, but multiple lookup queries to the same table is not desirable.
Concatenate address fields is also not what I want. I really want to be able to display the address fields as separate (read-only) fields in the purchase order table.
Ideally, the main table 'purchase_order' will get t1 as an alias and the address table t2 as an alias, etc ..
Is there a trick to get this done yet?
Best answer by Anne Buit
View original