One of the great features of MS Access is the interactive Table Relations Window, where you graphically create and review table joins. But once the joins start to multiply, the relations window becomes unwieldy, and understanding the joins is like untangling a hopelessly tangled ball of string. This is the relations window that greets you when you open the Access 2007 Northwind sample database:
click to zoom...
You can try moving tables around in an effort to get a better perspective, but perversely it appears even more tangled:
click to zoom...
My Ezy Documenter Premium Access add-in to the rescue! With the Table Relationships Report you can in one mouse-click easily review and automatically document even the most complex table relations - click on the screenshot to zoom:
click to zoom...
This report is only one of a number of reports that this Access Add-In produces:
click to zoom...
Check it out - only US$39.95 - demo available
