Trouble creating a report

[gardenlevel]

Hi.

I'm trying to create a report, but I can't figure out how to do it properly. Let me start with an overview of my db.

This is a basic project management db for a small group. There is a users table, which simply sets a user ID based on login. A Projects table and a tasks table.

Tasks are a child of Projects. So I can have projects without tasks, but no tasks without a project.

Here's my issue, I want to create a report that lists all Projects and its tasks. If I do this by basing the reports off of the child (tasks) any project without tasks doesn't get listed.

I also tried creating a report based on the Projects and using a portal to list tasks. It worked, but the layout was weird, and using "Sliding" didn't fix it.

[mr_vodka]

Ahhhh the old issue of FM's lack of outer joins.

You can either stick with the portal with sliding, or you can try to dump out to a temp table. There are possibly more advanced techniques using an intermediary table such like a hierarchy but I think it may be overkill.