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.

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.