parent child report
Have 2 tables:Project and Tasks Relationship: One Project can have multiple Tasks. I want to be able to display child records in the parent report without having to display them using a link. Is t...
Forum Discussion
Add the fields you to report on to from the Project table to the Task table as Lookup fields.... The are part of the relationship. Then create your report against the Task Table....and use the lookup fields that are created in the Task field from the Project table. I would recommend to Group and Sort by the Project name (Lookup Field). Let me know if that is enough for you to implement the report you want.
but this will not show projects which do not have a task associated with them. I am almost looking to do something like a left outer join on projects- if that makes sense.