Restricting Values in a Picklist

Restricting Values in a Picklist

I've created a form which stores Client information and each Client is flagged as being Active or Inavtive - this form is called [Clients].

I've also created a form for recording tasks against a Client; this form is called [Tasks].

On the [Tasks] form there's a field called {Clients} which looks-up Clients from the form [Clients]

I want to restrict the look-up to only show Clients that are flagged as ACTIVE. I've reviewed the various examples and help on the ZOHO website, but I'm not sure where the script should be placed against the field [Tasks], {Client} to filter the results.

Can you please confirm the required code and where it should be placed.

Thanks,
Martyn



martynhale