I have a form which shows fields that contain people's contact information.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10921-lookup-field-used-open-records-create.html
What I would like to do is have the last name field be a lookup field you can
use to choose which person's info to look at. You type in a last name, it
autocompletes, you either hit enter when the autocomplete is correct, or
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10921
scroll through the drop down list to choose a name. This I can do. The
problem is, I also want this field to be bound to the last name column of a
table so that if someone is entering a new contact, the information they type
in this field is stored as a new last name and they can fill in the rest of
the information. It seems like this should be possible, but I can't seem to
get all the stuff right. It seems I can only get it to be a field that they
enter information into or a field that opens a record. is there a way to do
both?