I have an issue with my application I was hoping to fix. I have two forms:

- Client (Has fields for "Client Name", and a Multiple Choice field for "Project Name")

- Staffing (Has a list of staff names, and Lookup fields for both "Client" and "Project" fields from "Client form"

I want to find a way that if the Client is selected in the Lookup dropdown, then the Project dropdown contains only the projects against their name in the "Client" form. Does anyone know if this is possible?

Regards,

David