Is there a way to have an auto complete field with an underlying id value to be used instead of what is displayed?
Suppose I have a list of golfers by name, I want the user to be able to type in the golfers name with auto complete - but the value I need for the database table is the id of that golfer record.
Golfer: name:Tom Buick id: 1 name: Tom Sawyer id: 3