Forum Discussion
ICD
Helper I
Helper ISlicers synchronization
I have 2 multi-select slicers: projects and buildings- based on 2 tables: Project table ProjectId -primary key ProjectCode 1 P1 2 P2 Building table BuildingId -primary key...
LeandroDeodato
Resolver II
Resolver IIshow you related please. you have a foreign key in Building table, but dont have this key in project table. try create a key with project code in Building table and related.
ICDHelper I
Helper IHi, LeandroDeodato
Sorry, my writing mistake : I changed the names of columns
Project table
| ProjectId -primary key | ProjectCode |
| 1 | P1 |
| 2 | P2 |
Building table
| BuildingId -primary key | ProjectId -foreign key | BuildingCode |
| 1 | 1 | P1-B1 |
| 2 | 1 | P1-B2 |
| 3 | 1 | P1-B3 |
| 4 | 2 | P2-B1 |
The relation is by ProjectId in the two tables