[nhusers] Advice on building sets

Hi! An application I'm working on has different items that, as an upcoming feature, should be assignable to sets: Items Id ProducerId ItemSetId (nullable) Name Weight ItemSets Id ProducerId Views Id

Re: [nhusers] Advice on building sets

Are you suggesting that the NULL ItemSet belongs to all producers? (If not, why should it be included when querying by producerid?) It sounds like what you want is a null-object - instead of using NULL for the itemsetit, you would have an ItemSet with e.g. id 1, that is _always_ there, and that