hierarchical fields - best way to define?

  • Thread starter Thread starter Philos
  • Start date Start date
P

Philos

I would like to represent a variable depth and width
hierarchical structure within an MSACCESS DB what is the
best way to do this? For example, the hierarchy may
represent the following product categories:

Supplier/
Supplier/Accessories
Supplier/Accessories/Desktop Computers
Supplier/Accessories/Pocket PCs
Supplier/Accessories/Desktop Computers/Mouse
Supplier/Accessories/Pocket PCs/Cables
Supplier/Accessories/Desktop Computers/Mouse/Wireless
Supplier/Accessories/Pocket PCs/Cables/Serial
....

Also what would a SELECT query look like to show all
items at a particular level?

Thanks
 
Back
Top