Thanks both of you! I really needed both answers, as I have other uses for accessing nested collections objects. James Bender Jackson/JTS

Has anyone figured out how to access (or if it's possible) a collection on a related column? I've been trying to get a report of all the step approvers for a project that's currently in an approval flow. Ultimately, my goal is to be able to report on whom a project is awaiting approval, so if you ha...

As Iddriss mentions, you use the OR:(1-999) syntax to create new combined or statements. For an example that matches a little closer your question about combining AND and OR statements, see the following: To get all projects where (Portfolio = HighGrowth AND Owner = Bob) OR (Portfolio = FixedAssets ...

The thing that stands out to me is the camel casing. Should be: setWorkUnit, setWorkRequired, setActualWorkRequired, setPlannedCost, etc... Second thought is that if you are creating a new task, you need a column named isNew and the data row to be 1. James Bender Jackson/JTS