Record Not Available When Using Left Inner Join of files

[bms1]

I have a browse on a parent file (Trips) using a left join on a child file
(Loads). I am using ABC template...I have the Trips as the primary file and
Loads as the secondary file. I also have the Trip file as part of the Other
Files. Randomly Clarion does not generate the correct SQL statement and I
receive Error(35) Record Not Available Errors. Is there a way to ensure that
Clarion generates the correct SQL at all times. I am using SQL 2000 as the
backened and 5.5h.

 

[JShankar]

Does both Tables have Primary (Unique) Keys and are the primary Key elements part of the browse display / Hot fields ? Since you have a Left Join does the Error appear only for those Trips without a Load? Have you traced the SQL generated using the SQL Profiler to see what is going wrong?

 

[bms1]

Thank you...after tracing the SQL, the error does occur when a load is not assigned to a trip.