22 Messages
•
405 Points
How do you show table JOIN relationships in a Data Set?
We are beginning to develop our inventory of Data Sets. It makes sense to use that you can select columns and tables to be added to the data set structure but how do you identify the face that these two tables are JOINED together on a PK and FK? It’s like using the Data Set to logically build a Database View…
Looking for best practices on this topic.
michaelreed
2 Messages
•
50 Points
2 months ago
I'd be interested in learning how you ended up solving this.
0
0
grantrollerson1
36 Messages
•
2.3K Points
16 days ago
There a Complex Relation Type OOTB called *Foreign Key Mapping* you can you. This can then be built on a composite key.
0
0