yes I know its a star-schema, but its not for the purpose of a warehouse/cube solution. This is a day to day system and the only design change I can think of for them to full fill an unlimited number of lookup items requests is to have Main table(id,code,name,description,<xml containing any number of child lookup data>), has anybody done something like this before?