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.DBF, LOOKUPTEST2.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
|
|