Pop Up : Choose Text In Number Field - comp.databases.filemaker

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.

On Mar 25, 11:27=A0am, Bill <bbcoll...@earthlink.net> wrote: > In article > <b0ac8e72-d751-4127-9a8d-b662d47c8...@k3g2000prl.googlegroups.com>, > > > > =A0Keith <francois7...@gmail.com> wrote: > > 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. > > 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 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@v11g2000prb.googlegroups.com>, geo6121 <geo6121@gmail.com> wrote: > On Mar 25, 11:27�am, Bill <bbcoll...@earthlink.net> wrote: > > In article > > <b0ac8e72-d751-4127-9a8d-b662d47c8...@k3g2000prl.googlegroups.com>, > > > > > > > > �Keith <francois7...@gmail.com> wrote: > > > 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. > > > > 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 > > 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 ? 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=A0pm, Bill <bbcoll...@earthlink.net> wrote: > In article > <090026c3-7967-4e54-a14d-9040ecadf...@v11g2000prb.googlegroups.com>, > > > > =A0geo6121 <geo6...@gmail.com> wrote: > > On Mar 25, 11:27 am, Bill <bbcoll...@earthlink.net> wrote: > > > In article > > > <b0ac8e72-d751-4127-9a8d-b662d47c8...@k3g2000prl.googlegroups.com>, > > > > Keith <francois7...@gmail.com> wrote: > > > > Hello Group, > > > > > I need some help. I've got an Id which is a number field. The Pop u= p > > > > for this field is based on the Id from the 1st field & the name fro= m > > > > the 2nd field & is sorted on values using the 2nd field. > > > > > When I typed the first few letters, the curser jumped to the name i= n > > > > 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 desir= ed > > > > name. > > > > > Is there a way to have the same results in v11 without changing the= Id > > > > field to text ? > > > > > Thank you for any insight. > > > > 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 > > > 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 ? > > 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 Thanks for your follow-up, Bill, I tried most of your suggestions but will test them all again - I'll be back.

In article <b0ac8e72-d751-4127-9a8d-b662d47c85da@k3g2000prl.googlegroups.com>, Keith <francois7675@gmail.com> wrote: > 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. 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 :o)

On 26/03/11 12:45 AM, Keith wrote: > 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. 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...

On Mar 25, 6:13=A0pm, 105 <corti...@internode.on.net> wrote: > On 26/03/11 12:45 AM, Keith wrote: > > > 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& =A0the name from > > the 2nd field& =A0is 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& =A0it wants a number for the search. > > This list is very long& =A0takes 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. > > 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... 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: > On Mar 25, 6:13 pm, 105<corti...@internode.on.net> wrote: >> On 26/03/11 12:45 AM, Keith wrote: >> >>> 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. >> >> 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... > > 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. << Some twisted issue with indexing? Is the language the same? >>

On Mar 28, 5:20=A0pm, 105 <corti...@internode.on.net> wrote: > On 27/03/11 3:17 AM, Keith wrote: > > > > > On Mar 25, 6:13 pm, 105<corti...@internode.on.net> =A0wrote: > >> On 26/03/11 12:45 AM, Keith wrote: > > >>> 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& =A0 =A0the name= from > >>> the 2nd field& =A0 =A0is 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& =A0 =A0it wants a number for the sear= ch. > >>> This list is very long& =A0 =A0takes a lot of time to scroll to the d= esired > >>> name. > > >>> Is there a way to have the same results in v11 without changing the I= d > >>> field to text ? > > >>> Thank you for any insight. > > >> 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 work= s > >> 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 t= he > >> 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... > > > Hello again& =A0thank you for the numerous responses but nothing > > helped ! > > > I trried *all* of the suggestions& =A0nothing 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& =A0it worked. I then unchecked the 're- > > sort' ... box& =A0it 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. > > << > Some twisted issue with indexing? Is the language the same? > =A0>> Thank you for your response. The language is the same. In fact, the same problem crops up in 3 different databases !

Similiar Articles:

How to Choose Report layout based on field validity - comp ...
How to Choose Report layout based on field validity Follow ... of a field are valid: a number in a number field is valid, but text ... Using a pop up menu for selecting ...

How to read a field value from pdf form in Java - comp.text.pdf ...
... Name" and "Email_Addr" should pop up ... copy annotations or elements - comp.text.pdf... Fonts in the document, number ... form fields using Java? ... fields ( text field ...

Vehicle Mileage Tracker - comp.databases.filemaker
... Date Field Odometer - Number Field Gallons - Number Field Driver - Text Field Cost - Number ... Format global_vehicle to to display a pop-up menu from a value list which ...

Copying highlighted text - comp.text.pdf
Convert text to number in pop up menu - comp.soft ... Convert text to number in pop ... Copy Highlighted Text" to the context menu for Highlighted text. Currently, if I choose ...

How to get a number with 2 decimal, whatever this number is ...
But then, Whether it's a script or a calc, we end up with text instead of a number. ... in a specific format - for that you need to format the number in a text field ...

Execute a FORMULA in text variable - comp.lang.xharbour
> > The problem was in the MEMO field, if you try to convert a memo field ... Convert text to number in pop up menu - comp.soft ..... the text in a pop-up entry might be a ...

Can an 'edit box' change to a 'pull down menu' during run time ...
... you could come to that would be to duplicate the layout, with the field ... Convert text to number in pop up menu - comp.soft ... Can an 'edit box' change to a 'pull down ...

Look up tables in Simulink - comp.soft-sys.matlab
... aerodynamic coefficients as a function of altitude, angle of attack and mach number. ... Look up tables in Simulink - comp.soft-sys.matlab C language in S-Function Simulink ...

attach script to field? - comp.databases.filemaker
If you take a regular field (text, number, date, time, etc) and set a ... There is a work around but it really only works with fields that are > formatted as pop-up ...

Converting pain text to TeX - comp.lang.awk
Instead, you're incrementing count for every field. You could have this ... Convert text to number in pop ... Convert text to number in pop up menu - comp.soft ... this ...

How to Insert Fields in Your Word 2010 Document - For Dummies
Choose Quick Parts→Field from the Insert tab’s Text group. ... The number of bytes you see ... click the field and choose Edit Field from the pop-up menu ...

iPhone Application Development : Working with Text, Keyboards, and ...
... to set its text. I’ve labeled my fields Place, Verb, and Number ... the Number field in the view, and then choose the Number Pad option within the Keyboard pop-up ...

7/9/2012 7:00:51 PM