Hello Group,

I need some help. I've got an Id which is a number field. The Pop up
for this field is based on the Id from the 1st field & the name from
the 2nd field & is sorted on values using the 2nd field.

When I typed the first few letters, the curser jumped to the name in
v10. I have now updated to v11 & it wants a number for the search.
This list is very long & takes a lot of time to scroll to the desired
name.

Is there a way to have the same results in v11 without changing the Id
field to text ?

Thank you for any insight.

In article
<b0ac8e72-d751-4127-9a8d-b662d47c85da (AT) k3g2000prl (DOT) googlegroups.com>,
Keith <francois7675 (AT) gmail (DOT) com> wrote:

Should work the same way in 11.

Make sure the value list is defined correctly and the field is set to
use the correct value list.

--
Bill Collins

On Mar 25, 11:27*am, Bill <bbcoll... (AT) earthlink (DOT) net> wrote:
Thank you Bill. I touched nothing, just opened the file in v11 - I
just checked, as you suggested, & everything is the same. Even if I
open it in v10, it works,

Any other suggestions ?

In article
<090026c3-7967-4e54-a14d-9040ecadf54b (AT) v11g2000prb (DOT) googlegroups.com>,
geo6121 <geo6121 (AT) gmail (DOT) com> wrote:

Strange. I run FileMaker 11 (running a number of databases from
successive earlier versions), and have not had this problem.

Some ideas:

Try deleting the value list, close the file, then open it and define the
value list anew. Maybe that will do some good.

You might also want to run a consistency check on the file (you need FMP
11 Adv to do that) to see if that indicates any corruption.

Maybe save as a compacted copy.

Might be a field indexing problem. For the value list to work, the
fields involved have to be indexed. Indexes can get corrupted. Could
turn off indexing for the fields, close the file, then open it and set
the fields to allow indexing as needed.

Could run File>>Recover on the database. That will check consistency of
everything and re-index all the fields that need indexing. it will give
you a detailed report of what it found.

--
Bill Collins

On Mar 25, 2:45*pm, Bill <bbcoll... (AT) earthlink (DOT) net> wrote:
Thanks for your follow-up, Bill, I tried most of your suggestions but
will test them all again - I'll be back.

On 26/03/11 12:45 AM, Keith wrote:


Some twisted issue with indexing? Is the language the same? Try making a
copy of the file (set) and opening one in fm10 and the other at fm11,
see if the behaviour is the same.


To have 2nd field display layered on an id first field, this only works
on the pop-up menu (PUM), and not drop down list (DDL) control style;
just to carify 'list'.


There also is a difference as to whether auto complete is available,
based on the PUM or DDL

There is also a distinction in the VL between displaying values from the
second field, and showing values from the second field.
display without show, allows specifying the sort (first of second),
display and sort, removes the option to specify first or second sort


All of which may be irrelevant...

In article
<b0ac8e72-d751-4127-9a8d-b662d47c85da (AT) k3g2000prl (DOT) googlegroups.com>, Keith
<francois7675 (AT) gmail (DOT) com> wrote:

The sort order of the Value List in FileMaker is irrelevant. Typing when
in a pop-up list / menu is an OS level function, not a FileMaker one (or
at least it is under the Mac OS) and works in any application, e.g. web
forms in Safari.

In a pop-up list typing the first few letters should take you to the first
list entry STARTING with that value or the next closest entry to it, i.e.
if you type "Ernie" and there are no E entries, you might be taken to
"Fred".

This means that as long as your pop-up list is displayed as "Name Number"
typing as you want it will work, but if it is displayed as "Number Name"
then it won't.

Helpful Harry )

On Mar 25, 6:13*pm, 105 <corti... (AT) internode (DOT) on.net> wrote:
Hello again & thank you for the numerous responses but nothing
helped !

I trried *all* of the suggestions & nothing worked !

However, I found a solution (!?). I clicked on 'show values only from
second field' which did not work the first time so I clicked on 're-
sort values based on' English & it worked. I then unchecked the 're-
sort' ... box & it continued working. I don't understand what I did &
would certainly like to. The only problem now is that the Id is *not*
showing.

Thanks again for all of your responses.

On 27/03/11 3:17 AM, Keith wrote:

<<
Some twisted issue with indexing? Is the language the same?
>>

On Mar 28, 5:20*pm, 105 <corti... (AT) internode (DOT) on.net> wrote:
Thank you for your response. The language is the same. In fact, the
same problem crops up in 3 different databases !