I'm setting up a database to contain all of the invoice and job file information for the company I work for. Each job usually consists of 2-4 items listed with parts numbers and so forth. However, some require up to 20 or more items.
How could I *correctly* organize my MySQL database (or any DB for that matter) so that there are fields available for those many items without having tables with 30-40 fields? Does MySQL have any feature for 'sub-tables' that are adjusted by list, not by field?
One idea I had, which seems inefficient, is to have the system create a NEW table for each order... and then have each table a customized number of fields based on the requirements of that particular order. Is that a good idea?
2006-11-14
06:03:51
·
3 answers
·
asked by
Anonymous