By Randy Long

Summary: Most of the data you deal with probably fits nicely into a parent/child, relational data structure. But sometimes you have data that works better as a self-join, where data in one table relates back to other data in the same table. Randy Long shows how to use trees, recursion, and many-to-many checkboxes to manage this kind of data.

Please log on to read this subscriber-only article. If you do not have a subscription you can purchase one in the ClarionMag store.