I have a table that has 2 foreign key. I would like to create in drop down that contain the value of these two foreign key. How
can I do that?
Here is my table definition:
Id INT Prinary key
IDLocation Foreign key to location table
IDDepartment Foreign Key to Department table
Master Table with data exammpe:
ID Primary key but this is related to the IDLocation Foreign key in Master table
Location Table with example.
ID Primary key but this is relate to the ID Department foreng Key in Master table
So in my drop down I would like something like this.
Chicago - Clothes
or "Value" - "value"