I have a form for new projects. I want to allow the user to select a contractor from a list of contractors to assign to the project. Each contractor also has multiple employees, one of which will be assigned to the project.

What I hope to accomplish is a filtered list of contractor employees based on the selection of a contractor in a lookup field.

Not sure how best to go about accomplishing this.

Any help greatly appreciated.

Best,

Chris