B
Brinker1975
If I have a form based on a query of two tables, then I can only update the
information from one of the tables. Is there a way to be able to enter info
in all fields?
I need to know how to handle this for more than one of my forms, but here is
one example: One form is for entering contacts. It is based on a query of
tblContacts and tblConsultants so that we know which consultant has each
contact. The only field from tblConsultants is a field indicating which
consultant this contact belongs to. ConsultantID (a number) is in
tblContacts, but I need the ConsultantIN (3 initials) from tblConsultants for
the form so we can tell who it is. I can get it to show up right, but cannot
enter anything into that field of a form.
Does anybody have any advice on my setup or how to fix this problem? I do
not know any code, so if coding is necessary, I would appreciate detailed
explanation of where to type it, etc.
information from one of the tables. Is there a way to be able to enter info
in all fields?
I need to know how to handle this for more than one of my forms, but here is
one example: One form is for entering contacts. It is based on a query of
tblContacts and tblConsultants so that we know which consultant has each
contact. The only field from tblConsultants is a field indicating which
consultant this contact belongs to. ConsultantID (a number) is in
tblContacts, but I need the ConsultantIN (3 initials) from tblConsultants for
the form so we can tell who it is. I can get it to show up right, but cannot
enter anything into that field of a form.
Does anybody have any advice on my setup or how to fix this problem? I do
not know any code, so if coding is necessary, I would appreciate detailed
explanation of where to type it, etc.