I would like to have a have a combobox set in dropdown list format display only rows belonging to the child records of the parent table. I am trying to select an active account and then display all patients belonging to this account with a combobox.

I can do this with a filter - but it is slow. Any ideas would be appreciated.
Thanks in advance.