sorry if this is a newb question, I’m quiet new at filemaker programming. I already searched in the forum but I didn’t find what is suitable for me.
I have a “project” table which allows to have multiple entries with the same name (but different IDs).
In another table I have an input field with a dropdown list that displays project’s ID and Name. I cannot display only the “second field” because in that way it gives me only once the names that appear many times (And also I like to see the ID too, in order to distinguish the projects)
But doing so, if I check the “auto complete with values on the list” box it expect that I type the ID first and then the name.
How can I make a custom “autocomplete” function in order to be able to type only the name?
I thought it would be great to have the possibility to dynamically create a list with the result of a “perform find” but I didn’t found any way to do that.
Any other idea?
Thank you very much