Dynamic Multi-Pass Hierarchy Prep Recursion

[#1]

Hi Everyone,

What's an elegant way to programmatically streamline the pre-Hierarchy function recursion passes for a (potentially variable) multi-column hierarchy?

I'm thinking the FieldName() and FieldNumber() functions, maybe following a few user-answered questions in variables (Ex. What's the starting column, and how many columns are part of the hierarchy?) are the key to making this into a loop.

Thanks,

DJ

[pover]

Why would you not use the Hierarchy or HierarchyBelongsTo function?

Regards.

[#3]

This is to prep the table for the Hierarchy and HierarchyBelongsTo functions.

[pover]

Ok, so the object of the script is to create a table with a parent ID in each row. Can you upload a same sample of the data you are starting with?

Regards.