I use auto-complete with value lists that draw their values from other tables all the time. Perhaps there was some problem in how you set up either the value list or the fields involved?
Another thing you may want to check... The fields that you want referenced must be indexed to be used in a Value list or auto-complete.
Please advise what I need to check for ?
My value list usually list the 1st field always to be the pk id and the second field the name -
The fields that you want referenced must be indexed to be used in a Value list or auto-complete
Please advise how to do this ?
That explains it. In my experience, this is an unfortunate limitation of Filemaker. When the first column is a hidden number column, auto-complete won't work. This is one of the cases where MS Acess and its feature rich combo box far outshines Filemaker.
TSGal would probably advise you to make a suggestion in the feature request form to request this feature.
Go into Manager Databases and then click on the field that you want. Then under options, go to the storage tab. The field should be set to at least Minimal indexing.
Yes I do have indexing - But Note comment from Phil where it seems because I am using the pk id as the primary field of my value list and the name as second field then this feature may not be possible in FM
The reason I use the primary key on the first field is so that when I select a field other fields prefill as per this selection
i.e. Value List= Guest Name the value list is set up for pk id on first field and last name on second field to search
On the layout I select the name and email, telephone number, and address pre fills from this selection
My question was to be able to start typing the last name of the person and the search will begin, but it seems this is not possible in filemaker -
Thanks for your input
TS Gal Can you check on this and see if I need to add this feature to a wish list??
To add a suggestion, go to:
Explain what you are trying to do, what barrier you are encountering, and how you would like to see it implemented.
Hi TS Gal,
What I am trying to do is something similar to what you do in MS Access - In MS Access I can go to a table view and move field to field with typing the first few letters of and auto finding the entry - Even though the field is filling in information coming from a value list based on another's table fields.
In filemaker I find that for a value list to work and maintain integrity accross I have to always choose the pk id first and then display the name - This causes two issues one I always have to have two fields on my layout one where I choose the entry based on id then the second field displays the name.
I believe this is the only way the value list will work- So for example I have a country list Argentina, Brazil etc
Then I have another table called Cities in here I have to choose the country from a value list the value list must be based upon a pk id first for that country and then display the country name. This way if in the country table I change the name of Brazil to Brasil it changes as well in the City layout.
Assuming the above is all true and this is the only way to do this
Then when I create a layout in report or table view I cannot move from field to field and start typing Argentina where it will recognize it but rather I am obliged to select from value list which becomes time consuming
In MS Access you can do this on a table view
So Please confirm that this is in effect something beyond what FM currently does and I will put it on your suggestion box
Sorry for the late reply.
Unfortunately, I have not used Microsoft Access. Perhaps someone with Microsoft Access can help out?
Yes, if the Country name is changed, the "pk id" field will not change, and all Cities in that Country are still related to the "pk id" field; not the Country name.
If you have a drop-down value list and enter "Arg", Argentina will be highlighted, so you can then press return to use that value and continue on.
"If you have a drop-down value list and enter "Arg", Argentina will be highlighted, so you can then press return to use that value and continue on."
Well, sort of, kind of and not as nice as MS Access does in this particular area.
When you are using a hidden column 1, you can't use the Autocomplete option, it's disabled. (that makes no sense to me.) You can only use the "type really fast with no mistakes" method that dates back to FMP 3 or 4 to do what you describe.
As I've already requested on the feature request form.
We need to be able to auto-complete when column 1 is hidden. We need more sort options. We need the option to display column 2 instead of the hidden column 1 for drop down lists as well as pop-up menus.