Allowing more than 2 types of values to be added to an input box
Hi there. I have a Filemaker Pro database where we have one input for "Account". Currently the control style for this Variable is set to "Pop-up menu" and the Values are drawn from a Values List called "Account". Essentially we type in the account number and the account name is then pulled through to the field from the Account values list.
Going forward I would like to be able to retain the historic information (so this field still needs to be able to convert the previously entered account numbers to account names using the Values List), but I would like to also add the ability for the user to simply type the account name directly into this field as well (account numbers are becoming redundant and users going forward will really only know account names).
Could someone give me an idea of how I can add this extra piece of functionality whilst retaining what is already there?
Additional - actually whilst it says it is set as a "pop up menu" it is actually a free type text field so I'm a little uncertain as to what has happened here!