I'm relatively new to Notes, and occasionally it takes me a while to find out how Notes does things. I wonder whether there are equivalent tools to do things that I'm used to having in other programming environments.
Now I *know* Notes data isn't relational, and that each form in a database just gives you access to different sets of fields for one big flat document structure, but there *are* field links between different forms in one database. I've inherited quite a few databases, and of course, there's no developer's documentation, so what I'd really like is some sort of report which will tell me:
1) What fields are used on each form, including shared fields and subforms. Then I can see the links between forms. For example, Access gives you a Tools menu option called Relationships, which shows this in a graphical format. I doubt I'll find anything like that for Notes, but a text report listing field names under form or sub-form headings would be fine.
2) What subforms are used in each form. Like 1) above, a text listing showing subforms under form headings is what I had in mind.
3) A list of documents within a database that have "missing link" fields. Kind of hard to describe this one - I'm looking for "lost" documents, say response documents who have lost their parents. This one is not so important as Nos. 1 & 2 above.
200 points each to experts that can give me links to the tools themselves which can achieve this - I'm afraid that I haven't time to trawl through the many Notes sites searching for them myself. Alternatively, has anyone written scripts that will produce these type of results from within each database?
I don't mind looking silly if these things are available from within the Notes desktop environment itself!