Correct syntax for retrieving a value from a parent table to a child table

[Sandro_Ingrao]

qual è la sintassi corretta per richiamare una valore di una tabella padre ad una tabella figlio?

ad esempio riesco a richiamare un valore dalla tabella padre:
[id figlio].[id padre].[valore tabella padre]

Non ho ancora capito come fare il contrario.

Grazie
what is the correct syntax for retrieving a value from a parent table to a child table?

for example I can retrieve a value from the parent table:
[child id]. [father id]. [parent table value]

I still haven’t figured out how to do the opposite.

Thank you

[Suvrutt_Gurjar]

It is not exactly clear what you are looking for but please take a look at the dereference expressions and " Dereference a List" section in the article below

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

In summary, to access a column value from the parent table in the child table, the expression format is

[Ref Column that references parent table in the child table].[Parent Table Column Name]

To access a column value from the child table in the parent table, the expression format is

[Reverse reference list type column in the parent table][Child table column]

This expression produces a list the column value of all child records related to the parent recod.