John Colby
jcolby at colbyconsulting.com
Tue Sep 2 11:46:38 CDT 2003
Has anyone ever seen / designed a documenter for relationships where the relationships are NOT specified in the database window? I am going through a fairly complex "relational" database where there were no relationships established, defining the relationships. In order to do that I am looking at all form's combos to determine the column(0) field and the field in the forms query that it is bound to. I also examine the link child / master properties of all subforms on all forms. Using this strategy I determine the fields in all tables that have manual data input methods. As I discover each "relationship" I create a relationship in the relationship window of the FE. This allows me to at least see the structure of the database as envisioned by the original designer. It seems like a process that could be automated but I have never done so. Has anyone else ever seen a tool that does this? John W. Colby www.colbyconsulting.com