creating a parse field

[e3digital]

I want to pull info from my Students table into my Enrollments table, simply by starting to type the students name and have the field populate with available possibilities depending on what's entered. (Like a pull down of sorts) So, if I enter an A, I would get Aaron, Adam, Angie, and Ann. If my next letter is n, the list would shorten to Angie and Ann.

I've seen this in action, but can't figure out how it was done. Any help would really be appreciated. Thanks in advance...

Susan

[Vaughan]

Do a search aound the Forums and the Internet for "clairvoiance" and "typeahead".

Most of these display the matching results in a portal. It requires some knowledge of relational design and multi-keys; it'd be a good way of learning them too. :