Joined: Thu Aug 10, 2006 9:43 am Posts: 7 Location: South West UK
|
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
|
|