Subject Re: Lookuprowset
From Peter <phb2020@hotmail.com>
Date Wed, 03 May 2023 16:18:27 -0400
Newsgroups dbase.getting-started
Attachment(s) ins_info.DBFLOOKUPTEST2.wfm

Hi Mervin,
I am able to use the form as you have shown below.  
I am trying to modify the form to do the same thing with
Insurance Information, such as Ins_code (2 character field) and Ins_name (40 character field).  User enters 2 letter code for Ins_code and OnKey function does a lookup in Ins_info file to show full length Insurance name and puts it in entryfield2.
Something is wrong.  Ins_code is not found. Entryfield2 shows \\\"Invalid Ins Name\\\". In addition when setfocus() goes back to entryfield1, there is only one space.
Can you find my error?  I have attached the lookuptest2.wfm, Ins_info.dbf. If no .MDX there, index on Ins_code
          Production MDX file: INS_INFO.MDX
          Index TAG: INS_CODE  Key: INS_CODE

I have another question, but I'll wait until this gets fixed.
Again, thank you.

Peter