Form filtering during data enrty

[Matt_Engle]

i have an app that references a table that has currently active jobs with job number and name and job manager.

when i select the manager from the enum list, i only want the jobs that the manager is assigned to to be able to be selected from a drop down list in the next form entry section.

is that possible