Forum Discussion
Bridge table: Can't display the visual
I created a bridge table to have common column for the Table 1 and Table 2 as seen below:
Their matching column is the Config. Number and the MODEL_ITEM. Config number in the Bridge table are the combined of the two fields from table 1&2.
The problem is that when i add the Config. Number in Table 1 to the display with the Lowest Component in the Table 2, it shows no visual.
Can you help me fix the problem so that i can show columns from Table 2 corresponds to Table 1?
Hi, Anonymous ;
I don't understand why bridge tables are used here，If you're using bridge table, and when Table1‘s "A" .what do you want to show when A has values 1 and 2?
One method is First, last or count itAnother is delete bridge table ,and use many to many relationship.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Greg_Deckler
Community Champion
Anonymous You either need to use the column in your bridge table or change your relationship direction to Both from your Table 1 to your bidge table.
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
I don't understand why bridge tables are used here，If you're using bridge table, and when Table1‘s "A" .what do you want to show when A has values 1 and 2?
One method is First, last or count itAnother is delete bridge table ,and use many to many relationship.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
