Subject TIBOTable.Locate on a lookup field fails
Author masonwheeler
Got another fun one for you.

Create two database tables, linked by a FK relationship.

Create two TIBOTable objects, one for each table.

Use the form designer to create persistent fields for one of the TIBOTable datasets. Give it the fields the underlying table has, plus one more, a field of FieldKind fkLookup, that looks up a property on the other dataset, using the FK relationship.

Create a routine that tries to call Locate on this dataset, and use the lookup field for the Locate key field.

Expected: It should work. This will work on normal datasets.

Observed: EIB_StatementError. FieldName: [lookup field name] not found.

It appears to be looking for the field in the underlying dataset, and then bailing when it's not found.