Okay, I designed an order database with many fields and several linked tables. 3 years ago, we noticed that after about 1000 orders were entered, the database got really slow, the queries didn't want to run and records started becoming corrupt or disappearing altogether. So, we started separating them out: we essentially copied the database, deleted the old records and started with the next batch of orders.
Now, 9 databases later, I need the ability to search all the databases (or at the very least, the 4 most current ones) for a customer's reference number. So far, I've gotten as far as linking the tables from each database to the current database, but since the order number and customer reference number fields are named the same in each linked table, I am finding it hard to be able to view all the info on one table or query so that I can do a FIND for the number I'm looking for.
I'm really at a loss. Maybe this isn't possible.
HELP!
Now, 9 databases later, I need the ability to search all the databases (or at the very least, the 4 most current ones) for a customer's reference number. So far, I've gotten as far as linking the tables from each database to the current database, but since the order number and customer reference number fields are named the same in each linked table, I am finding it hard to be able to view all the info on one table or query so that I can do a FIND for the number I'm looking for.
I'm really at a loss. Maybe this isn't possible.
HELP!