[AccessD] relationship documenter

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




More information about the AccessD mailing list