I have two tables that are related with a field on one table and the primary key on the other in a one-to-many relationship. (One table for names, other table with a field for the name) I have set up a listbox on a form with the data from the names table. Right now, I can pull a name off the list and place the ListID number in the name field, which is fine.
What I’d like to do is to be able to start to type the name in the listbox field and if the name is there, save the Primary Key number in the field; or if the name isn’t there, add that name to the Names Table and save the new Primary Key number.
My questions are can I do this, if so, how, and do I use a combo or listbox?