AnsweredAssumed Answered

Autocomplete and Dinamically Modifying of a Value List

Question asked by sdrammaturgo on Sep 29, 2018
Latest reply on Sep 30, 2018 by sdrammaturgo

Hi everyone,

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

Outcomes