I have two fields: one "Department" and two "Team Member".
When I select say "Claims Department" from the first drop down I would like the second drop down to be populated with the "TeamMember" of only the "Claims Department".
I would like to achieve this with 1 or 2 SharePoint lists due to easy editing due to turnover and easy training hand off from IT.
Any help would be greatly appreciated. I would like to stay away from InfoPath.