Make one Reference variable Dependent on two Another reference varable in Same Custom Table.

[Balaram7]

Hi Everyone,

We have requirement to create a custom table for Categories.

Which have fields like Category Name, Environment and Roles Required.

We have multiple categories, environments and roles. 

For this we have created a custom table with the three fields and loaded all the data into that table and in the catalog item, we have created three reference fields Category, Environment and Roles.

Now when we select category, We need to display only unique values and, in the environment, also we need to display particular categories which are listed under that category and in a similar way based on the environment selected roles associated with that category, environment need to get displayed. 

Can anyone suggest me the best way to achieve this.

Thank you,

Balaram.

[Mark Manders]

So, if I understand correctly, you have created one table holding the data and you have 3 fields, referencing that table and you want them to interact? That's weird. 

It sounds like you are looking for a category/sub_category/sub_sub_category kind of relation, right? Select category, only showing the environments for that category and then only showing the roles for the dependency on environment?
Why not just add it as choices to the system with dependencies? I am not getting the custom table here and I must say the requirement being to create a custom table is weird. There must be a requirement and based on that the best solution could be creating a custom table, but I am missing the requirement here.