After a meeting yesterday, I can add a new column to the table and use it with a lookup table. I can't fully modify the table due to other apps...

I agree with you  10000%, however, the DB was created before I joined the project, so I'm kind of stuck with some of the table structures at this time.

I need to show all of the data from table 2

I'll check out both of these examples over the weekend, thanks

That table has more then the { id } and { code } in it. I only showed those two columns do to the { code } column can show...

The { Code } column is used to see what region the logged in user can see. The ID column is just  an ID column for that row and is...

So, after a 2 hour meeting, I can make whatever changes  to the table as needed. So, to make this work, I could create a new row for each code...

I can modify the table very little, not much due to it's used by another app. Thanks, I'll take a look and see if I can get the recommended solution...