That would still give me multiple parent records in REPORTCURSOR though. Forget about the report. All I want to do is create a cursor from two tables that have a one to many relationship where the one table only shows in the FIRST record REGARDLESS of how many records are created by the child table.
So instead of:
---COMPANY-------DIVISION----
Company Name Division Name 1
Company Name Division Name 2
Company Name Division Name 3
I want a cursor that looks like this:
---COMPANY-------DIVISION----
Company Name Division Name 1
------------ Division Name 2
------------ Division Name 3
Thanks!