Forum Discussion
Dimension Table Relationship
Good morning, I am attempting to connect a table to my existing simple model. Using the model below. I can create a table visual and add elements from the Project Table and Procedure Table, but when...
Hi nchamilton162 -If the Procedure Workflow History table has a column that matches a column in either the Object Relationship table or the Project Table, use that column to create a bridge.
The bridge table could include unique IDs or a combination of keys that link Procedure Workflow History to the existing schema.Connect the Procedure Workflow History table to the bridge table with a one-to-many relationship.
If necessary, connect the bridge table to the Object Relationship table or Project Table.
Ensure fields from Procedure Workflow History flow correctly via the bridge to interact with elements in your model.
I hope creating bridge table works in your scenerio . please check