I've recently been given the task of moving a project forward that consists of turning 15 pages of forms into one summary sheet form. (There are even more projects after this)
The problem I'm having is that no one is sure of how the data in the database is logically structured, where the linkages are, and which forms or sub-forms the data is being pulled from.
I have printed the data dictionary, but this is really not a big help, it doesn't list any of these properties.
The database is quite big with over 77,000 pages of information (about 552MB).
What I need to do is get a map of the structure and linkages of the data.
I have downloaded an article on the archtechture of notes to try and help me (I haven't had time to read it yet tho..)
I am open to converting the notes database to something else to to see the structure, I know this kind of map is available in MS access, but I am not sure how to do this either..
Any help would be appreciated..