Selectind Dependant Field

Questions
1

Can we set dependent with multiple arguments.
for example Select CouseName from Course where DepID=:lookup_depID and Semester=:lookup_semester