I have this relationship:
In the Activity Record, the Type and Task exist as dependent dropdown lists.
I would like [Task] to display a list of it related options as a report when a parent Type is selected.
Can this be done?
You can set up a conditional dropdown by going to the Related Task field and using the checkbox for Conditional Dropdowns. You would then set it so a selection in Activity: Related Type shows choices where Activity: Related Type=Task: Related Type. The link below is to our help article that discusses conditional dropdowns. If you need more help with this you can always submit a support case and we'd be glad to walk through it with you.
Conditional Dropdowns: http://www.quickbase.com/user-assistance/Default.html#conditional_dropdowns.html
Thanks for your input. What I'm actually looking for is the dependent drop down to instead be in the form of an embedded report. So, I'd select an option from the parent dependent drop down, then, the child dependent would behave a bit differently. I'd want that child list to be in the form of a full report of the options for reference, rather than another selection list.