General ideas please

[wwiSports]

I am getting ready to revamp two databases into one. One of them is a lead entry db where we enter name and school, this one counts the number of entries made per person, etc... That databases is doing good though it need's some design changes to make it more appealing to the eye. That db need's to be added to the orders db.

The orders db is on the other hand complicated and overrun by querries that are just not needed, as well as features that are not used that need to be deleted.

We need to get these two databases together because we need to be able to see who that we mailed to from the lead entry database actually ordered in the orders database.

I am trying to start the process and trying to figure out if I should either import all features from the old databases into a new db and make changes there, or completly start from scratch. The time frame on this is pretty short.

Beth

 

[FoxProProgrammer]

Are these two databases in Access presently? It doesn't sound like you need to start from scratch. Why not just create a new Access database. Import the tables that you need, and even the Queries , Forms, and Reports, etc. if they are from another Access database. Then add whatever field you need to the tables to relate them and you've got it. dz

 

[raymondo]

Why not just create a new DB and import only those bits that you really want from the old DBs. Starting from scratch with only a short time frame is a sure recipe for a big increase in stress levels.

 

[ggreg]

I think I would try importing the two, I think tho
I would work with the orders one first to cut out what is not needed and then make sure what is needed is still working. Then I would bring in the other one because it is the one with the least changes to make, and then would work out on what was needed new(the reason for joining the two databases)