Page 1 of 1

Lookup for memo files

Posted: Tue May 09, 2017 3:22 pm
by Cliff_Wiernik
We have a lookup function for numerics, dates, logical and character fields, why not for memo fields.____Otherwise we have to do formal relations for each lookup we need which is a pain. I would like to just create the lookup function. Using the text file lookup is not a good answer either as we cannot specify the location other than when the report is saved. We have 20 lookups for different types of stipulations plus many others for promotion program and other messaging in our customer credit decision form. ____We cannot use the ri_master/ri_mindex fields to specify the file location and we share the report definitions among many companies from a single shared location.____No certain why this limitation exists.

=> RE: Lookup for memo files

Posted: Mon Jun 05, 2017 1:24 pm
by cstrasser
A lookup on a memo would be a good idea. Unfortunately, these types of fields are treated very differently by Xbase, being kept in a separate memo file with only a pointer to the specific location for a record.____We^re looking into making memos more accessible within R&R in general, including the ability to perform text functions.