Hi,

I have two tables that I need to map, a case table which has a column called case_type which contains a string code value eg "ABC"

The full details of the code value eg long description is contained in the CODELIST table

On the face of it I could map this with a many to one mapping however the CODELIST table has a primary key made up of two columns

CODEVALUE = case_type on the case table
LISTNAME

The problem is LISTNAME is not stored on the case table

Is there any way to do the equivilent of a many to one but include some kind of where clauses disciminator in the case table mapping file?

Any other approaches to solve this?

Thanks
Richard