We help IT Professionals succeed at work.

Lookup information for field 'X' is incomplete - error msg

froggybird
froggybird asked
on
Hi,

Please help.. I am not an expert in Delphi, yet :-) and been left with an application to convert from Delphi3 to Delphi5. Since the conversion, when the app is opening a table I get the following error message "Lookup information for field X is incomplete".

Thank you.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2004
Commented:
complete the lookup-information, or delete it

you've somewhere a persistent field, which is defined as lookupfield. in this definition an entry is missed (keyfield, lookupsource, resultfield,..)

Author

Commented:
kretzschmar,

Thank you for the quick answer.

Not sure I'm going in the right place.. I went to the table Update Table Definition, and in that problematic Fields, I have all lookup properties completed (KeyFields / LookupCache / LookupDataset / LookupDataset / Lookup Keyfields and LookupResult). To double-check I deleted this field and re-added it making sure I have all Lookup Definition fields entered.. still the same error message..

Am I looking at the wrong place?

Author

Commented:
Sorry kretzschmar, i was not looking at the right table (silly me), thank you very much.
CERTIFIED EXPERT
Top Expert 2004

Commented:
thanks :-)

glad to helped you
good luck again

meikl ;-)

Commented:
Use "Fields Editor" -> "Add New Field" and create lookup there, you will not forget anything.
In my case "KeyField" was missing.