To start off, I have three tables.

ITEM
ID
ItemName
Descrition
InventroyNumber
AVP
ItemValue
DateRequired
Media

CategoryItem
ItemID
CategoryID

Category
ID Key,AutoNumber
ParentID Text
Title Text

------------------------------------------------------------------
Basically I'm going to have Category as a Subform on the Item Form. I want Category to be displayed as a TreeList or TreeView including only the Title-Primary Node and ParentID-Child Node using ComboBoxes. Each Item can have mulitiple Titles(ex. Child Care, Adult Care, etc) and one or multiple ParentIDs(ex. Child Care Equipment, Playground Equipment, etc) The Data Entry Person will have the freedom to create the Tree only using the Values given from a seperate Category Form.

The help I need is creating that TreeView.:confused: I've seen other posts and sites where a TreeView is created with values embedded in the code, but I want to be able to edit and add the Tree using values from a Form. Thanks for the help!