I've got 4 files - 3 are in database SynergyOne and one is in SyneryFinance

 

The problem I've got is this. I have left outer joins going from 1 file vStudents to 2 files (vStudentsAddress & vStudentsTransport in Synergyone) and to vDebtors (SyneryFinance).

 

Basically I'm trying to pull all details for every student into a crystal report which is basically a contact form.

 

Problem I have is that it's not bringing back null values for the left outer joins. It is only bringing back information for where the vstudent = the other file's details. I want all the vstudent records to be displayed with whatever details are associated with it in the other files.

 

Regards Torben

Convert Other NULL Values to Default but still does not show all records wanting. Even ordered links to the other 3 files