I have an employees field. One field is [Employee], second field is [Employment Status]. I am trying to create a drop-down list that only shows the Employee whose status is Active. (this is on another table) I have the relationship already built for both fields to the other table.
Make a simple report of just Active Employees with just the names as your drop down choices. Call it something like dropdown list of Active Employees. Set it to be visible to no Roles.
Then on the FORM properties for that field select the form to not use the Record Picker, but instead use your report.