Hi --

I have a PROJECT form, then a TASK form linked through a lookup field.

I need to be able to assign one or more tasks to people records in another form.

I thought I'd do with two lookup fields, yet I want to task lookup to be filtered to only display tasks pertaining to the first project lookup field, so only tasks from this project will be displayed in the second lookup, what formula should I use?

TIA.

— AB