Basically what I want to do is a name based auto-complete edit-box (or something similar) that allows users to start typing in a name and of course suggest the correct name (the list of names can/should be pulled from the existing contacts table). When the user confirms the name I want the ID associated with that name to be put into the foreign key field (not displayed on the layout).

The layout itself is based on a "Teams" table which has "Team Members" which is a "Contact". The only field shown on the Teams layout is a first+last name calculated field.

Teams: _TeamID

TeamMembers: _TeamID, _ContactID

Contacts: _ContactID

The "ideal" solution would be a field that shows a dropdown where as you type the dropdown's value list starts to filter based on what you type, not a "go to" auto select.

I apologize if this is the wrong sub-form. (please move it to the correct one)

For those wondering, in the end I gave up and went with a pop-up style auto-filtered-as-you-type portal (ala nightwing)