[rt-users] Custom field relationships

[Joe Harris]

We are running 3.8.8.  We have some custom fields we would like to
auto-populate using scripts.  Basically, like so:

customfield id = 1 - Client/Project
customfield id = 2 - Task/Code

In the create new ticket form, the data in Task/Code is dependent on
what is chosen in Client/Project.  I cannot for the life of me figure
out how they are related within the database structure.  I know it has
to do with the sortorder in customfieldvalues, but I cannot see where
they are related.  We want to script on the backend updating the
information based on data that pulls from another database.  We hav
the data to load, just need to figure out how to relate them.

Any ideas?

Thanks in advance!

Joe