Trees in Access

[stoutfellow]

Does anyone know how to implement a tree structure in Access?

As I mentioned, I want to organize my keywords into a tree, so that (e.g.) the keyword "Location" has children such as "Europe", "Asia", etc., and "Europe" in turn has children "Ireland", "Great Britain", and so on. It seems that the obvious way to do this is to have each Keyword record have a "Parent" field, containing the ID of the parent keyword.

So far, so good. I want to construct a form which will show a keyword and a list of its children, and which will allow me to add more children to that list. Thus far, I haven't been able to get the latter to work. Any ideas? ("Use a different database program" will be considered only as a last resort....)

Comments

[subcreator.livejournal.com]

Try this.

http://www.vb123.com/toolshed/00_accvb/treeview.htm

I didn't read all of it, but it sounds like what you want to do.
Thanks - Peter

[stoutfellow.livejournal.com]

It's in the ballpark, yes, but I figured out another way to get what I wanted. It's macro-based, so it's probably not quite as efficient as something implemented in VB, but it seems to work. Thanks anyway!