HI all. I have a question when i use ref in the formula.
I have two tables, PO and PO detail. In the PO table, I have the columns, Customer, Address, Phone, Email, Website...
and in PO detail I have the same column as PO. Because I use ref in the Po detail In the normal I will use the function in each column in the PO detail table like:
Column: Customer -- Formula: [PO].[Customer]
Column: Address -- Formula: [PO].[Address]
Column: Phone -- Formula: [PO].[Phone]
......and more
I think a good way to make my job is easier to create a formula for all the columns like
[PO].[[_this]] or [PO].[[__thisrow]], my idea is the result will return the columns in the PO table by the name of this table(PO detail).
I think it's not reality, but I wanna ask is it impossible or any ideas for making this case easier?
LinkedIn
Twitter
