Hi experts,
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]
Hi @UmairAhmed
What data source are you using for your app? If it's SQL Server, you could use a View to simplify this.
Hi @timl,
Datasource is Dynamics365 CRM
@timl wrote:Hi @UmairAhmed
What data source are you using for your app? If it's SQL Server, you could use a View to simplify this.
Hi Umair
I've got the same issue and was wondering if you ever got this resolved? Is it at all possible to do this?
Cheers!
User | Count |
---|---|
139 | |
97 | |
89 | |
78 | |
56 |
User | Count |
---|---|
194 | |
186 | |
106 | |
99 | |
91 |