Is it possible to define a value list as a subset of records within one table?

[Rapt Productions]

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

[comment]

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