Hi guys,

I'm really stuck here, I have searched through the questions and have tried
a few suggestions but nothing has helped.

I'm creating a form using datasources from Lists within SharePoint.

The first drop down box contains a list of departments,

The second drop down box is meant to find a list of people from the
sharepoint list within that certain department.

I don't understand how I can filter this because I see the message
'filtering is not supported in browser enabled forms'  

Has anyone got any suggestions about how I can filter this data?

Thanks for any help