I am trying to find the best strategy for designing a database that will contain items with sizesand possibly other options. These items may have a unique item number associated with a particular size. I am not sure whether it is best to create a unique record for each size of each item or to create extra fields in the database to identify each size and it's associated item number. There seems to be advatages and disadvantages to doing it either way but there must be a standard model for this sort of thing. Can anyone give me any help? Thanks.