Category
View Builder
Product Version
9.0
Single Reference Table - joins
Answered
Hi
I have a reference table for Country codes with Country names. Our DB schema has multiple tables having only Country Codes. To allow the end user to see Country names - is there a way to make the country code reference table join with multiple tables? What will be the suggested solution in this use case
Thanks and Regards
Rajesh
The same question
You can join a table multiple times but you can introduce circular joins
If that happens, you can just pull the table into the model builder again and just join that to whatever table you need to
You can join a table multiple times but you can introduce circular joins
If that happens, you can just pull the table into the model builder again and just join that to whatever table you need to
Hi Rajesh,
As Dean mentioned above, you can join the country code reference table to multiple tables. The view builder's Table Options panel lets you configure it:
I hope that helps!
Kind regards,
Chris
Hi Rajesh,
As Dean mentioned above, you can join the country code reference table to multiple tables. The view builder's Table Options panel lets you configure it:
I hope that helps!
Kind regards,
Chris
Hi Rajesh,
I hope things are going well over there.
Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.
Regards,
Chris
Hi Rajesh,
I hope things are going well over there.
Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.
Regards,
Chris
Replies have been locked on this page!