As we know, auto-complete is not supported in drop-down list when the value list used is configured to use Also display values from second field. The situation I have is the referenced table has 3,500 entries. As such when the user uses the pull down they can put in just the first character, for instance "M", but can't do anything more than that. The list is long.
The list however won't change that much. Can I copy the list into the regular defined value list section via a script of some sort whenever a record is added or deleted from the reference table? I would set the value list up and then just update upon a change.
Is this possible?