Hi,
Thank you for reply.

Do you meant that, your item records may look like this?

ItemID                ColourID              SizeID               ClassID
00001                 RED                   56                   A
00001                 YELLOW                56                   A
00001                 BROWN                 56                   A

There will be 3 item records with same itemid but may be diff colourID, classid and sizeid?

Thank you