G
Guest
I'm trying to allow users to enter new contacts into our database. Ideally
I'd like them to be able to either enter a new company or choose from an
existing company. We're dealing with foreign suppliers so we may get several
with different spelling variations if they can't choose from an existing
supplier.
I made that entry field a combo box and have it query values from a table
the data is not being put into. It gives me an error "the value you entered
isn't valid for this field" when i click on the combo box tab. It then shows
the list of all companies.
How do I get rid of the message? And any good thoughts on how to deal with
an unlisted supplier smartly? It's my first database build from scratch, so
I'm sure these are basic questions. Thanks in advance.
I'd like them to be able to either enter a new company or choose from an
existing company. We're dealing with foreign suppliers so we may get several
with different spelling variations if they can't choose from an existing
supplier.
I made that entry field a combo box and have it query values from a table
the data is not being put into. It gives me an error "the value you entered
isn't valid for this field" when i click on the combo box tab. It then shows
the list of all companies.
How do I get rid of the message? And any good thoughts on how to deal with
an unlisted supplier smartly? It's my first database build from scratch, so
I'm sure these are basic questions. Thanks in advance.