Benginner2212
Member
- Local time
- Yesterday, 21:50
- Joined
- Apr 6, 2023
- Messages
- 52
I am trying to re-create a database for equipment tracking at my work. The problem that I am not sure how to handle is importing some of the data from the old database into the new database. The old database has four tables that I have to get data from but some of the data that I need from each table is linked to data in another table. For example I need to import the field LastNames from the table title Manufactures, but the field LastNames in a one to many relationship with the manufacture field on a table titled Assets.
I have been playing around with importing the Manufacturers and Asset tables then using an append query to move the data to correct tables in the new database I am creating, but I am not sure if that will keep the relationships between the table and records in the tables intact or not.
Thank you for any help in advance.
I have been playing around with importing the Manufacturers and Asset tables then using an append query to move the data to correct tables in the new database I am creating, but I am not sure if that will keep the relationships between the table and records in the tables intact or not.
Thank you for any help in advance.