Thanks again Cindy for you response but its a bit more complex than that.

The main Table contains Claims made to the company. One claim can have several third parties. The Third Parties are striped into 3 Tables (Vehicles,Persons and Properties ((Each T/P Table have different fields.)).
So for each claim I download all vehicles,persons,properties in question into one cursor called thirdParty. The posibility exist that there are no third parties.

If there was just one table for for tp I could just do a left outer join which would still get all claims and include any t/p that exist but the tables are split.


I want this format for the report


Claim Code Insured Name Phone
------------------------------------------------------
cscs10303 Christopher Pinnock (876)924-1234


--> Name Vehicle # Insurer Tp Type
-----------------------------------------------------------------
Terry Jolly 5545 BJ United General Insurance Vehicle
Lyndon Wheeler BCIC Property
Corey Brown Person



cscs10303 Barry White (876)924-1234

--> Name Vehicle # Insurer Tp Type
-----------------------------------------------------------------
Pete Samphras 5445 CD BCIC Vehicle




cscs10303 Keith Brown (876)924-1234
cscs10303 Pete Abrahams (876)924-1234