Record Producer - Lookup Select Box

[Laura12]

I've found a few questions in the community forum already and I followed a few of the instructions as listed but I can't get my 2nd dropdown (the lookup select box) to show any values.  For this record producer, I'm mapping to and using a custom table.  The second dropdown, Practice Group, is dependent on the first dropdown, Primary Practice Area. So on the form, they will select a Primary Practice Area from a dropdown and then in the next field, Practice Group, they should only see those values dependent on their first choice.  Most of what I read said to use the sys_choice table but I'm not sure if using the sys_choice table is correct for the second dropdown, because I'm not getting any values.  For the first dropdown, I'm using a select box with the choice table = custom table and choice field = Primary Practice Area.  I've added some attachments....any thoughts? 

[Aman Kumar S]

I don't think you should be using sys_choice table at all, have a lookup from table as Practice group and add a reference qualifier for the Primary practice area that you already have in place in the screenshot.

[Laura12]

That's what I was thinking because at one point, I did have it pointing to the custom table but then I'm not sure how to write the reference qualifier and do I also need a variable attribute?  

[Aman Kumar S]

Refer to below article how you can achieve for Lookup select box

Reference Qualifier on Lookup Select Box Variable

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂