I built a product spec database.
- Forms, Queries and reports are all managed by me.
- stores a record of each product we create
- allows new products to be added as time goes on
- Prints reports to ensure compliance with specifications
- approximately 1000 records, will probably continue to grow
Now I need to build a database that will be used to record quality assurance checks on the same products from the product spec database.
- forms will be used by our QA department to enter results of daily QA checks
- primarily used for data entry and trend analysis.
- will add a few hundred records each day
- needs a few fields from the Product Spec database to perform weight calculations.
I'm trying to decide if I should create a completely new database or just add more tables / forms/ reports to the one I already have. I worry a little bit about the database getting too big and un manageable, but wanted to get a some thoughts before I went one way or the other.
Thanks
Bruce