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 |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |