Thank You all,

after all your inputs i am sticking with 3 tables and a view to populate the Models.

There is another argument that is going on my team , need some input on this

Sample data:

Table Name:Master_Market

mid--Market

101-USA

102-UK

103-INA

Table Name:Master_Product (FK to Primary of Master_Market )

pid--mid--Product

1001--101--P1

1002--101--P2

1003--102--P1

1004--103--P3

Table Name:Master_Model (FK to Primary of Master_Product )

id--pid--Model (id-Identity,PK - [pid-model] )

1--1001--M1

2--1001--M2

3--1002--M1

4--1002--M3

5--1003--M1

6--1004--M2

7--1004--M3

8--1004--M4

if i want to populate models for INA & P3 by using the VIEW the input should be

1. Should i pass 'INA' & 'P3' as string. i.e. actual values

OR

2. Should i pass '103' & '1004' as string. i.e. actual values

here the question should we use internal id or the actual values ? when we are fetching the data ?

Thank You