I would appreciate your help in solving my problem:
I have three tables Building, Appartment, Residents and I have to Filter Residents based on selection of Building and I have to display Residents with Appartment name.
Building Table has ( BuildingName, BuildingID)
Appartment Table has (AppartmentName, AppartmentID , BuildingID)
Resident has (ResidentName, AppartmentID, DOB, Gender)
Building has one to many relation with Appartment
Appartment has one to many relation with Resident
I want to display Resident Name, AppartmentName in the List. I would appreciate your suggestion to solve this. I tried using ClearCollect with Lookups but could n`t able to work out.
Regards, Umair Ahmed
I have tried this:
First I filter Direct Child
ClearCollect(BuildingAppartments,Filter(Appartments, AppartmentID = BuildingGallery.Selected.BuildingID));
Then for the Grant child I am trying below
ClearCollect(ResidentAppartment,"Resident",LookUp(Residents,AppartmentID= BuildingAppartments[@AppartmentID] ))
I get below errors
Invalid ArgumentType on "="
Delegation warning on BuildingAppartments[@AppartmentID]
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.