Icon View Incident Report

Serious Serious
Reported By: Larry Lustig
Reported On: 11/20/1998
For: Version 1.07 Build 1
# 245 Performing a Lookup on a Detail Table of a Master-Detail Link Causing a "Record Not Found" Error

I'm getting an error 8710 Record not found in data file when I click to drop down a DBLookupComboBox. I've read the description of this error in the DBISAM error file, but I'm still not sure what's causing it.

In this particular case, three tables are involved -- The datasource for the DBLookupComboBox, the lookup source for the DBLookupComboBox, and a third table which is providing the master key for the lookup source table which is on the detail side of a master detail relationship.

The help file indicates that the <ErrorFileName> should appear in the error message, but I don't see it. In this case it would really help.

Comments Comments
The problem was with trying to do a lookup on a detail table of a master-detail link. The data access components were mistakenly re-setting the range in the process of looking up any values. The Locate functionality (used by the lookups) has been modified to use a filter instead under such circumstances. This error also occurs with the BDE, but there is no fix for the BDE.

Resolution Resolution
Fixed Problem on 11/29/1998 in version 1.08 build 1