Transfer data from one table to another

[Guest_imported]

Here is the low down...
I have two databases, one new, one old. They are both 2000 at this time. I want to get the information from the old DB to the new one, without losing any information.

Sounds easy..? Well, here is the problem. In the new DB, everything is pretty much sorted by Employee ID (an Autonumber). and each employee is then assigned stuff, like Keys, equipment, etc... The old DB is not, it is centered off of things like Key type, etc...

Question is... How can I get the multiple instances of one employee's name to show up just one time in the new database, but still have all of their info be attached to their name?? Please help if you can.

Thanks

 

[jerseyboy]

cantremembername,
Sounds like a one-to-many relationship to me. If you were to import the tables into one database and keep them seperate then all you would have to do is use your autonumber as a foreign field in the second table. Sound confusing? Okay here goes...

You have John Smith as employee 222 in the new database.

You can import the "old tables" and assign 222 to john smith everywhere he is loaned an article.

You could create a query to automatically do that without too much trouble. One that is done for all of the names then creat a form (parent) to display the employee information: Name Rank Serial Number.. and then a subform to hold the articles that person has loaned to them.

Write back if you need further help,



JerseyBoy
Remember: self-praise is no recommendation