I am having a problem with one of my lookup buttons.
Here are the details:
I am using 4.31 and I have lost track of PR number but the SAF date was Feb 2 this year.
The table being looked up is a In-Memory table with a unique key, but the value needed by the calling form is not a component of the key.
The browse procedure, which is used solely to do this look up, displays the In-Memory records properly, but when Select is clicked the record is not selected. Using the After Lookup, Before More Assignments embed on the calling form, reveals the record buffer of the lookup table is empty. On the calling form, the look up settings are:
URL: the look up browse procedure
From File: the In-Memory table
Order by: the unique key of the In-Memory table
Value field: the field of the In-Memory table needed by the calling form
On the look up browse:
For the Table schematic: the In-Memory Table with the unique key
Unique,unchanging key: the unique key of the In-Memory table
Fields: the value field and one other display field
On the Form tab, only the Select and Cancel button are checked. A dummy form for the In-Memory table is entered as the Form control just in case
The dummy form has the In-Memory table with the unique key identified as the unique, unchanging key.
I should mention that the look up worked fine until the last NetTalk update, and that other lookups that have a physical table with the value field the same as the unique key component also work fine.
Unfortunately, this look up is required and central to the application function, so any help would be greatly appreciated. Thanks in advance.
Topic: Lookup problem (Read 7109 times)