Cascaded UDGrids

Universal Dashboard
1

I currently have two tables in the same DB: Family and Individual. Family is the parent table, while Individual is the child and they are joined by FamilyID.

I would like to create a dashboard that has 2 grids, one for each table. In the FamilyGrid I should be able to select any row and the IndividualGrid will filter through all the results and only show those individuals with the same FamilyID as the one selected. When a new Family is selected the IndividualGrid should refresh and show the respective Individuals.

I have the following but I’m not sure how to get the FamilyID for the current record and how to sync the IndividualGrid.

Thank you for any help you might be able to provide.

#Family/Home level
$Cache:SQLFamily = @"
               SELECT * from Family
"@

$SQLSiteParams =@{
    Serverinstance = $server
    database = $DB
    query = $Cache:SQLFamily
    As = "PSObject"
}

$Cache:SQLApplicant = @"
               SELECT * from Individual
"@

$SQLSiteParamsApplicant =@{
    Serverinstance = $server
    database = $DB
    query = $Cache:SQLApplicant
    As = "PSObject"
}

New-UDPage -Name 'Family' -Icon dumpster_fire -Content {
    New-UDRow -Columns {
        New-UDColumn -Size 6 -Content {       
            New-UDGrid -Title "Family Grid" -PageSize 15 -Endpoint    
                $site = Invoke-SqlCmd2 @SQLSiteParams
                $site | ForEach-Object {
                    [PSCustomObject]@{
                        FamilyID     = $_.FAMILY_ID
                        FamLastName  = $_.FAMILY_LAST_NAME
                        HHSize       = $_.HOUSEHOLD_SIZE
                        Select   = New-UDButton -Text "This Button" -onclick {
                            Show-UDToast -Message “You clicked the button!!!!”
                        }
                    } 
                }| Out-UDGridData                                
            }

       New-UDColumn -Size 6 -Content {       
            New-UDGrid -Title "Applicant Grid" -PageSize 15 -Headers @("Applicant ID", "First Name","Last Name") -Properties @("APPLICANT_ID","FIRST_NAME","LAST_NAME") -Endpoint {   
                $Cache:site = Invoke-SqlCmd2 @SQLSiteParamsApplicant
                $Cache:site | Out-UDGridData                
            }
        }
    }
}