How do I display and enter data for a data hierarchy in access?

[Guest]

I have a two tables that describe a hierarchy in access 2007. I want an easy
to use form to define the hierarchy. What is the best/easiest way to do this?

* I have one tabel with Item records (ItemID, ItemName)
* I have one table describing the relationship of Items (RelationshipID,
ParentItemID, ChildItemID)
*I want to be able to att records to both the Item tabel and to the
ItemRelationship table
*I want to visualy see the relationship
* One Item can have several child items
* One item can have several parent Items

what is the best/easiest way to do this in access?

/H

PS I am kind of looking for a quick and dirty solution since this is not
really a "project", it is more of a hack for a thing for a friend

 

[Stefan Hoffmann]

hi,

I have a two tables that describe a hierarchy in access 2007. I want an easy
to use form to define the hierarchy. What is the best/easiest way to do this?
* I have one table describing the relationship of Items (RelationshipID,
ParentItemID, ChildItemID)
* One Item can have several child items
* One item can have several parent Items

Sounds like a mesh, not like a hierarchy. If it's one, then use the
TreeView.


mfG
--> stefan <--