Creating a File Tree

J

John Ortt

Hi there,

I have a table which documents the update process for an access database in
the following form:

Master Type Slave Type
--------------------------------------------------------------
None None Autoexec Macro
Autoexec Macro DeleteOldData Macro
DeleteOldData Macro DeleteTable1 Query
DeleteOldData Macro DeleteTable2 Query
Autoexec Macro AddNewData Macro
AddNewData Macro AddTable1 Query
AddNewData Macro AddTable2 Query

I would like to create a colour coded visual flow chart based on this data.
The colours would signify the type of activity, i.e Blue for a Macro, Red
for a Query etc.
The Master/Slave relationship determines the shape of the tree.
For the example above it would look something like:

Autoexec DeleteOldData DeleteTable1
DeleteTable2
AddNewData AddTable1
AddTable2

Any help or recomendations are greatly appreciated.

Thanks in advance,

John
 
Top