Hi,

Due to integration with an existing datamodel and databse I need to map two tables into one object. For example, a vehicle has a make, model and a colour, these are represented by lookup tables, referenced by primary key from the vehicle table. I can easily map this using a one to one from vehicle, but the vehicle class already has methods for getModelCode, getModelDescription and similarly for the vehicle make/colour. Is there anyway to do this, without creating a Make/Model/Colour object in the vehicle class? Have searched in vein so far :( The relationship is always one to one...

Thanks,

Chris.