Lookup broken after conversion to 12 from 10
I typically type in a quantity, then tab into the look-up field which is a drop down. I then start typing in the item name (must type quickly tho) and the item(s) will appear in the list... well thats the way it worked in v10... in v12 I just get warning beeps whenever I hit a keystroke while in that field, and the drop down list does not advance to the nearest corresponding item.
Thanks for you response
I have FM12 running on a Mac Pro OS 10.6.8... same as it was before conversion
It looks up (lets call them) "Parts" from a related table
Just some background - I had a fellow put this solution together for me some time ago but can't seem to contact him anymore I'm not a developer, but I do like to work my way around the system
The behavior you are seeing happened first in FileMaker 11.
For More Information see: FMPA 11 Drop-Down List Bug 1
This is one of many acknowledged bugs that can be found in the Known Bug List thread here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: http://www.4shared.com/file/8orL8apk/FMP_Bugs.html
Thank you sir for your time...I"ll browse thru those links, and hopefully the answer will be there
Unfortunately there is no "answer" really. This is something that used to work on Macs and now doesn't.
I've never been a big fan of the "type really fast to scroll the values by 2 or 3 letters" method anyway. I prefer more sophisticated approaches that update with each keystroke as the user enters more and more data. This can be done in Filemaker with a bit of scripting and design work.
http://www.4shared.com/file/plr_jbkk/EnhancedValueSelection.html
Thanks again
My lookup list has over 80,000 items in it, and it gets updated about once a month. The updates are converted from a Windows coma separated (converted to tab separated in text edit) file which are downloaded usually on a monthly (automatic) schedule.
Each record has a control ID no. as well as 12 other fields, I've added a field that I use as a "short name" (that I memorize) to type into the drop down.
On any given update from Windows, any one or number of records can either be modified, deleted, or added... so you see its quite complex (at least to me)
Cheers
The updates are converted from a Windows coma separated (converted to tab separated in text edit)
Hmmm, that seems like an unecessary step here to me. CSV files can be directly imported into FileMaker. They shouldn't need to be edited into a tab separated file in order to be imported into FileMaker.
I definitely would not try to use a simple ID number based value list of 80,000+ items--that'd drive a user crazy. I'd analyze the data in order to use conditional value lists where you select a category first then pick from a value list that only displays items from the specified category, and/or I'd use one of the enhanced valuelist selections that are in the demo file that I shared. That demo file shows off 3 different ways--an auto-complete enabled drop down and two filtered "search" portals that automatically filter down to fewer and fewer possible matches as I type more and more info into the feld.
The Windows program creates a .DAT file that I bring into "text edit" on my Mac, then do a "find" for comma's. and then a "replace with" tab.
Getting back to my lookup stuff: The sequence I use is as follows. I enter a quantity, then I can either single tab, or double tab to start typing my lookup. The single tab puts me into the lookup field that doesn't work anymore, it has 2 field names, the first one is - ::LU_Type, the second one (under the first one) is - ::_kf_partsID. Now if I tab twice after the quantity entry, a new window opens that allows me to enter my unique ID (which is called "short name") ... Here's part of what I see in edit mode
Edit - When using the pop-up window method, everything works fine... I just cant use the "description" field for lookup, I'm forced to use "short name"
To repeat, FileMaker can import data dircectly from a CSV file. You can edit the file extension to change it to .txt or .csv before importing--a much simpler change than what you are currently doing.
With regards to the drop down list, I've already suggested alternatives and provided you with a download link to a demo file so there's nothing more there that I can add.
Thanks once again for your time, it is very much appreciated
In your opinion, what is the best 3rd party manual to help one better understand (learn) FM Pro
I don't have an opinion on that as it depends far too much on the person acquiring the book--what skills and experience they bring to the book they choose to learn from.
You may want to go to a web site such as Amazon where you can read reader reviews on each product and choose for yourself.
How is your value list defined? What options are specifed in Manage | value lists and on the data tab of the inspector?
What operating system? Have you change OS platforms?