Hello, I created a database in Access many years ago before I realized what a mess lookup wizards would make. Does anyone have any good ideas or resources of how I can keep the information but undo the lookup wizard?
I have created new tables with the same information and new fields that do not have relationships of any kind yet. I have tried to run update queries to copy the information to the new fields but the update queries are not working.
I now realize what a mess this is and I want to start over.
The whole reason this is coming up is because I am trying to export the information for other uses. I need the information that is in the lookup wizards too.