Both for an Inventory DB I'm working on, and for general knowledge for future,
wondering about the following situation -
Intentory Item (parts) table, approx 2000 records at this time, having the usual
fields; Vendor, Manufact., partNo., etc. For about 25-50 of these
records(parts/items), will also print separate labels which will use three
fields that are different. For example, while these 25-50 will have Description
field in common (among about 22 other fields in common), they will also have a
LabelDescription Field (a very shortened version of the description, to fit on
label), in addition to one other LabelNumber and Catagory which all the rest of
the records/parts/items won't have.
Because it seems illogical to have fields in which you know 98% will be blank,
should I make a separte table for these, using the 3 fields plus the PK key from
the Item Table? That doesn't seem right, either.
Thanks, Josh
|