Use formula for Ref

[JOHNN]

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? 

[TeeSee1]

The main idea  behind a parent - child architecture is that you do not have to RE-create cols that are in the parent table in the child table.

What is your use case in creating these 'duplicate' data in the child table in the first place?

[JOHNN]

I create the same columns in the child table as the parent table because I want my data to be enough for the information when the user sees the child table. The case in the real is the user goes to the child table( PO detail) and sees the PO001 but they didn't know what is the Customer of PO001 or what is the phone of the customer of PO001. one thing they can do is go to table PO to see the information of Customer.

[TeeSee1]

Curious.. Your users first go to a detail.

But then I see if you want to avoid one action, you need to include the PO's header detail in the child row..

Another possibility is to create a dashboard view with a child (PO detail) table view at the top, a child detail and a parent (PO) detail side by side at the bottom with interactive mode on.

This way when you user selects a PO detail row at the top then the related details are displayed.

[Yogi_Hayate]

Are you trying to fill PO details with values from PO tables?

[JOHNN]

No, i try to fill the PO detail by the formula like [PO].[ (name of this row)] because name of this row is the same as the name of the column in PO so they will return the value of column PO. 

[graham_howe]

The simple answer is that what you want to do (effectively automatically refer to a column name in one table based on the column name in another table) is not possible. Column names can not be derived in expressions, they have to be typed in.

[Steve]

Not possible.

[JOHNN]

Thank Steve