Record Producer - Lookup Select Box
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2022 06:54 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2022 07:08 AM
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.
Aman Kumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2022 08:13 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2022 09:58 PM
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 🙂
Aman Kumar