|Subject:||Re: Lookup Table fine when I open it, but not when I touch CNTL-SPACE
|Date:||Sun, 1 Jan 2017 06:43:38 -0700
|From:||Liz McGuire <email@example.com>
I think he's using the built-in, table-level lookup feature, and this
feature sorts alphabetical (I think) on the lookup field (which makes
sense in a vacuum - which is where they had to develop it). To my
knowledge, the lookup table wouldn't (need to) be in the data model.
A.C. the rest of us roll our own lookup forms rather than using the
built-in feature - which can cause problems. Rolling your own gives you
a lot more control and options.
You can find an example on http://rdaworldwide.com/resources.html under
Code Samples - search for "Custom Lookup" and you'll find it.
On 31 Dec 2016 18:27, Tom Krieg wrote:
> Have you checked to see whether an index or a sort order is specified in
> the data model of the form?
> On 1/01/2017 2:14 AM, A.C. Fairbanks wrote:
>> I am running P9.
>> I have a lookup table that appears just fine when I view it using File
>> | Open | Table. That is, it displays with the sort order I need.
>> But then, if I open a form that has a Table Frame, and I touch
>> CNTL-SPACE, the table lookup view opens, but sorts in a different
>> order from what the lookup table itself uses.
>> I had understood that the CNTL-SPACE view would display using the
>> underlying structure of the lookup table itself, but that seems not to
>> be the case.
>> Why would the lookup table display in two different ways depending on
>> the method I use to display it? And, how can I get the CNTL-SPACE
>> version to display as does the table itself?
>> Many thanks,