database design

We are trying to figure out the best way to (re)design a database for our Q.C. department inspection record system. There is a seperate paper inspection record form for each part number that is inspected
(over 10,000). This form contains the data for all the inspections
done on this part over time. The form (inspection record) contain mostly all common fields except for a handfull of fields that are unique for each part (its paticular inspection requirements). Currently we are developing a flat file database with a seperate table
(over 10,000) for each part (looks just like the paper form). The
problem is trying to perform a query across all tables. Does anyone have any ideas on how to perform a query with this large table count or a better database design idea? Received on Wed May 30 2001 - 21:40:01 CEST