Lookup for memo files

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Posts: 142
Joined: Tue Oct 10, 2017 12:44 pm

Lookup for memo files

Post by Cliff_Wiernik » Tue May 09, 2017 3:22 pm

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.

User avatar
Posts: 155
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Lookup for memo files

Post by cstrasser » Mon Jun 05, 2017 1:24 pm

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.
Chris Strasser
Liveware Publishing, Inc.
Work bigger.

Post Reply