A lot of programs have "Clairvoyance", the ability to FIND a likely match as you type in a name or place or .... It seems that with trigger scripts, etc. this is possible and reasonable. However, it might be very cumbersome and slow.
Surely, someone out there has done this. What experiences have you had with this and what works best?
For a text field, you can select auto-complete in the inspector to get clairvoyance. This can be clairvoyance from all other records in the table or it can auto-complete from the text values entered from a value list.