Hi,

I have a very simple problem, but I dont know if it is possible to do it in Sugar - I have tried every combination I can think of.

I want to list all "Projects" and their "Project Tasks".

I only want to list the "Project Tasks" which fit a criteria (for example, I have a custom field on the 'project task' called task_type.)

I only want to list all projects but only their project tasks where the "project task" task_type is 'Billing Task'.

Is this possible in Sugar?

Thanks,

Michael