Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Can anyone guide me on how to link these two tables ?
pivot_tree:
pivot_tree_helper_table
The expectation is -
when I select Task B in pivot tree table, the data model should select the correct task_id in the pivot_tree_helper_table
But I am unable to link the two tables
**I cannot add any new rows into the first table as it's being utilized by a pivot table. Although, I can add more columns.
*** I cannot break the pivot_tree_helper_table into smaller tables, as I need to link task_id to further tables in my database. It will create circular reference.
Thanks!
Sagnik
Try
linking Name1 Name2 Name3 in both tables with a composite key
It would be great if you could help me understand with an example.
Suppose the candidate key for 4th row in first table is ABC, then how I am supposed to connect it with other table in the runtime ? I will have the same candidate key for 3 rows.
Thanks!
Sagnik
I think I would load both tables with a crosstable-statement and then consider if it's better to concatenate both instead of linking them.
- Marcus