I’ve done some searches, but it’s possible that I’m not searching on the right terms, or perhaps that I just don’t understand the answers, but I’ve not found the information I need.
I’m relatively new to Access, and I’ve been pleasantly surprised with how robust of a solution it’s turning out to be. As for my experience, I took database classes to get my Bachelor’s so I understand basics of database design.
I came to this company a couple years ago and was handed a database that tracks plan review projects.
1 Project can have many reviews
1 review can have many plan checkers
In the old database, the Project and Review information was stored in one table. (Plan Checker information is something I’m adding to the database in the new iteration.) Something like this.
ProjectInfo
——————-
id_ProjectInfo
PlanCheckNum
ProjectName
ProjectDesc
ContactName
ContactNum
Comments
ItemsRecieved
DateIn1
DateOut1
SentVia1
SentTo1
DateIn2
DateOut2
SentVia2
SentTo2
DateIn3
DateOut3
SentVia3
SentTo3
Etc…
I’ve dealt with the horrid nature of writing queries and reports on this database, and decided to do a complete redesign. I’ve created a new database structure with three tables. One for Projects, one for Reviews, and one for PlanCheckers. I’ve created relationships, written reports queries, and created nice forms using bogus data, etc. I’m REALLY pleased with the new design and how it turned out. My question is this:
How do I get the data from the old database to the new one while keeping the relationships intact. I mean, a project could have up to 4 reviews in the old database, but they’re all in one record on one table. Is there an easier way to do this than exporting the single table to Excel and manually fiddling with the data before importing?
