Single Reference Table - joins

Rajesh Kumar shared this question 4 months ago
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

Replies (3)

photo
1

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

photo
1

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:

/03128637c86fe7ece5a678712e6fdbbc

I hope that helps!

Kind regards,

Chris

photo
1

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

Leave a Comment
 
Attach a file