M
Mariebob
Hi,
I am currently trying to document the links between objects in a database
(i.e. this form calls this report, which uses this query, etc.).
I have created a table called "tbl_object_links" with 3 fields : id
(generated primary key), object, calls_uses_linksto. As I document the links
in my database, I enter data in those fields (using listboxes created from
MSysObjects).
The problem is : the same object can be found in the two fields, since it is
obvious the same object can call or be called by another.
Example :
Object Calls_uses_linksto
Form1 Form2
Form2 Query1
Query1 Table 1
Query1 Table2
And so on...
I want to make a report allowing me to see the entire "tree" for each
object, but I don't know how many links there will be and how to proceed.
Am I going for it the wrong way? Is there an easier method?
Thanks,
I am currently trying to document the links between objects in a database
(i.e. this form calls this report, which uses this query, etc.).
I have created a table called "tbl_object_links" with 3 fields : id
(generated primary key), object, calls_uses_linksto. As I document the links
in my database, I enter data in those fields (using listboxes created from
MSysObjects).
The problem is : the same object can be found in the two fields, since it is
obvious the same object can call or be called by another.
Example :
Object Calls_uses_linksto
Form1 Form2
Form2 Query1
Query1 Table 1
Query1 Table2
And so on...
I want to make a report allowing me to see the entire "tree" for each
object, but I don't know how many links there will be and how to proceed.
Am I going for it the wrong way? Is there an easier method?
Thanks,