Pass through Record to Nested Table

[JamesMcEwan]

I am looking to pass through the value of a record to a nested table within the same record, below is an example table where I am trying to pass through Name from the parent record into the nested table. I have also commented out the function I was trying to use. 

let
    Source =    
        Table.FromRecords(
            {
                [CustomerID = 1, Name = "Bob", Order = 
                    Table.FromRecords(
                        {
                            [TransactionID = 1, LineID = 1],
                            [TransactionID = 2, LineID = 2],
                            [TransactionID = 3, LineID = 3],
                            [TransactionID = 4, LineID = 4]
                        }
                    )                
                ],
                [CustomerID = 2, Name = "Jim", Order =  
                    Table.FromRecords(
                        {
                            [TransactionID = 5, LineID = 1],
                            [TransactionID = 6, LineID = 2],
                            [TransactionID = 7, LineID = 3],
                            [TransactionID = 8, LineID = 4]
                        }
                    )
                ]
              
            }
        )
   // CustomColumn = Table.AddColumn(Source, "Custom", each Table.AddColumn([Order],"Name",each _[Name]))
in
    Source

[JamesMcEwan · Accepted solution]

Fount the Solution:

let
    Source =    
        Table.FromRecords(
            {
                [CustomerID = 1, Name = "Bob", Order = 
                    Table.FromRecords(
                        {
                            [TransactionID = 1, LineID = 1],
                            [TransactionID = 2, LineID = 2],
                            [TransactionID = 3, LineID = 3],
                            [TransactionID = 4, LineID = 4]
                        }
                    )                
                ],
                [CustomerID = 2, Name = "Jim", Order =  
                    Table.FromRecords(
                        {
                            [TransactionID = 5, LineID = 1],
                            [TransactionID = 6, LineID = 2],
                            [TransactionID = 7, LineID = 3],
                            [TransactionID = 8, LineID = 4]
                        }
                    )
                ]
              
            }
        ),
    CustomTable = 
        Table.AddColumn(Source, "Custom", 
                each 
                    let 
                        ParentName = [Name],
                        AddName = 
                            Table.AddColumn([Order],"
                                Name",
                                    each 
                                        ParentName
                            )
                    in 
                        AddName
            )
in
     CustomTable