Hello, I've got a self-joining table in which each record can have a parent record and multiple child records within the same table, like so:

(people)

client vendor employee (artist)

(performer) studio_artist

actor (dancer) musician

ballet jazz hip_hop modern belly

(values in parentheses are parent records to the subset below)

I'd like to be able to create value lists using this hierarchy, i.e.

a performer list which gave me a choice between actor, dancer, and musician, and which in turn let me choose one of the types of dancer. Because of the directions in which my company is expanding, I need for end users to be able to create these value lists, rather than hard-wiring the tables myself (which is why I set up the hierarchy of records to begin with.) Is this even possible? How do I go about it? Thanks for taking the time to check out my post!

RAPTZILLAredux.fp7.zip

It's sort of possible, but unlike the relationship, the number of choices will be by necessity limited by the number of fields you provide to make them. So I am not sure having these infinite hierarchy levels is helpful for this purpose.

RAPTZILLAredux.fp7.zip