> It's really clear what you want. Please specify.
> If what you basicaly want is just a tree structure, then it's done like
> CREATE TABLE something (
> id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
> parent INT NOT NULL,
> data1 CHAR(255),
> data2 CHAR(255),
> Then you can specify the parent node id for each record in database.
> This is how tree-like structures are stored in SQL. Hope that helps.
That is ONE way to store a tree structure :-)
Another would be:
(ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
primary key (ItemID, ParentID)
I prefer the latter.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL