Forum Discussion
mtomova
1 year agoHelper III
Relationships in data model does not work - breaks table visual
Hi, I have a pretty simple data model, which consists of 3 tables: * property table * measures table (one property can have multiple measures) * installation works (one property can have mu...
- 1 year ago
Hi mtomova ,
I wanted to check if you have had an opportunity to try the bridge table approach.
mtomova
1 year agoHelper III
Hi, thank you, I thought that the 'bridge' table is the proper approach if we want to combine the data.
I have never done it before, but will give it a try and see how to relate the tables.
As for the LOOKUPVALUE, wouldn;t that throw an error, because I will return multiple match per property_id?
v-sshirivolu
1 year agoCommunity Support
Hi mtomova ,
I wanted to check if you have had an opportunity to try the bridge table approach.
- v-sshirivolu1 year agoCommunity Support
Hi mtomova ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you- mtomova1 year agoHelper III
Hi, it did, thanks for the help!