I am working with an old Access Database where the creator did not know about normalization or using key fields. He just kept adding columns for each project to connect the line to from one table to then next. No key fields were used and all connections for reports were done in queries that had only indirect links. Every report was really done manually.
example:
company table
————–
company
company code — made up field that is used as a indirect connection
address
phone
main contact
phone
contact2
phone2
contact3
phone3
…
They maybe 60 fields or more on some tables.
Any suggustions as to where to start untangling this mess?
