LIST DEREFERENCE

[jaichith]

Hi there,

I have a doubt in list dereferencing.

Lets assume : Table A ( Parent Table), Table B ( Child Table).

Parent Table A will be having list of related child records of child table B ( in the image: [ Related order ]). Now my question is [Order Date] will return list of some dates. but which table dates does it return ? Parent Table A or Child Table B? In simple words [Order Date] values belongs to which table ?

I have not worked with this type of expression.

Kindly help.

[JeeHill]

Hey** @jaichith **

The [Order Date] values come from Table B (Child Table).

Here’s why:

• [Related Orders] in Table A is a list of child records from Table B.
• When you do [Related Orders][Order Date], it pulls the [Order Date] values from each linked row in Table B.

So, the dates belong to the child table (Table B), not the parent (Table A).

Hope that clears it up! Let me know if you need more details.

Jee

[jaichith]

ok buddy thanks .