transpose table

I have three tables

table 1: typeId, productid, TypeDescription, ExpDate

table 2: ProductId, ProductDescription, Size, Color

table 3, typeId, properyName, propertyValue

Give the typeId I have to return a recordset with 2 columns Name and value.

For table 1 and table 3 the Name column would contain the names of the tables columns and value column would contain the values.

For table 2 the Name column would contain the PropertyName and the value column would contain the PropertyValue column.

I want to generate a recordset with all the data for one typeId.

Is there an easy way to do all of this?

Thanks in advance

Malkie

[720 byte] By [malkie] at [2008-1-2]