Subject Re: [IBO] LookupCombo
Author Geoff Worboys
> But then when I close the form I get the message "Record was not
> located to update " and all is lost.

This sounds like a keylinks problem in the main dataset. Either the
keylinks of the record you are editing are not valid or perhaps a
trigger is altering the value underneath IBO.

Normally IBO can automatically determine the primary key of a table,
however if the table does not have a primary key (or if the select
statement is complex) then IBO may not be able to work out the primary
key for itself. I normally provide the keylinks information myself

If you have just inserted the record, perhaps there is a trigger setup
which is changing the primary key so that the information in IBO is no
longer valid. Make sure that any generator assignments in your
triggers check that the value is null before assigning a new generated


Geoff Worboys
Telesis Computing