project filter question

Hi,

After searching high and low for a GTD application that fits the way I work, I found Zoho Creator and it's great! The only problem I'm having is in filtering out inactive projects. I have 2 tables:

Projects -- here's where I dump all projects and ideas for projects; I have a field "Active" where I input Yes, No, or Barely

Tasks -- where I input all of the tasks, each one related to a project from the Projects table

I created a view that allows me to sort the data in different ways. When I review the task list to see what I need to do now, I only want projects that are active to appear in the Project drop down list filter. But since the task list is attached to the tasks table, not the projects table, I can't seem to create a filter to show only projects where Active = "Yes".

I tried Deluge scripting but nothing works.

I'd appreciate any help with this, thanks.

Sharon