topic Re: Linking two tables with multiple similar columns in App Development

Linking two tables with multiple similar columns

sagnikrana — Sat, 16 Nov 2024 02:47:57 GMT

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

Re: Linking two tables with multiple similar columns

Alarkis — Fri, 03 Apr 2020 20:57:31 GMT

Try

linking Name1 Name2 Name3 in both tables with a composite key

Re: Linking two tables with multiple similar columns

sagnikrana — Sun, 05 Apr 2020 18:51:22 GMT

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

Re: Linking two tables with multiple similar columns

marcus_sommer — Mon, 06 Apr 2020 09:29:44 GMT

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