Value lists can also be set to auto-complete on the Inspector's data tab.
You may also find the following script ehanced demo files showing methods of selecting a value helpful:
There are several different methods demo'd in this file. To get a copy in .fmp12 format open the file from your File menu: https://www.dropbox.com/s/0pm1gdqcfi2ndpv/EnhancedValueSelection.fp7
These linkcs are for two different copies of the same file. It illustrates a slightly simpler option for using a name to select a value from a value list and yet still link records by an ID number instead of a name file:
FileMaker 12 users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fmp12
Pre FileMaker 12 Users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fp7
Once you have looked up a name, the methods in this thread show two different approaches for "auto-filling" other fields based on which value is selected: Auto Fill
Yet again Phil you have come through in fine style!
Thank you so much mate!
ad another notch to the tab