Make a field dependent on another one

[adam_cannon_23]

I have 2 fields in a form, one pulls the Account name from the Case Table and the other pulls the Assignment Group from the Task Table.

I want to be able to set the following up so that when I select Customer A in the Account drop-down, only Assignment Groups 1-5 can be chosen instead of all 10 that we have

I know you can do dependent fields for drop-downs but it doesn't seem to like it across different tables.

[ersureshbe]

Hi,

I believe that the group table 'sys_user_group' includes an out-of-the-box field named 'Type' that will assist in accomplishing this. Please verify that the configuration is correct.

[Mark Manders]

Can you elaborate? Accounts that are used on the Case forms are references to the customer_account table which is a child of the core_company table and Assignment groups on the Task table (so also on case) are references to the sys_user_group table. 

What are you pulling from where and what is the result you are looking for? What is your form used for?