I have table A with Code and other fields and table B with Code, description and language. I want to associate these two table to show the Code and other fields from table A with description in user langugae from table B to the user. Now, the primary key in table B is composite, but not all the fields of B is availble in A (language is missing). What do I do? If I try to create a surrogate key in table B (using an identifier) then the primary key won't be composite, but I cannot use the same identifier in table A. Because if I put the identifier say 123 for combination 1, Some_Desc, EN languge in the table A, then the data becomes language specific whereas I should store the data non-language specific to be able to display in user languge!!! I am stuck with this, please help.