Data entry on joined query

[Guest]

I have a query in which one field is joined between two tables. I'm trying
to enter a new record, but can't enter anything in the field that is joined.
Is it possible to do this, and if so, how?

Clarification: Two tables, tblTeams and tblContacts. Each table has a field
[Employee#] which is the joined field. The idea is this: tblTeams has
[Employee#],[First], [Last], and [Team] . tblContacts has many fields for
contact information plus a field [Employee#] to identify who made that
contact. I want to be able to know which Contacts have been made by which
teams (this occurs on a subform).

Everything works fine, but I can't add a new record from the query mode.
Any ideas?

 

[Pat Hartman\(MVP\)]

Select the Join field from the many-side table rather than from the one-side
table.

 

[Guest]

I have tblContacts.Employee# in the query. Is that not the "many" side? How
do I tell?

Select the Join field from the many-side table rather than from the one-side
table.

I have a query in which one field is joined between two tables. I'm trying
to enter a new record, but can't enter anything in the field that is
joined.
Is it possible to do this, and if so, how?

Clarification: Two tables, tblTeams and tblContacts. Each table has a
field
[Employee#] which is the joined field. The idea is this: tblTeams has
[Employee#],[First], [Last], and [Team] . tblContacts has many fields for
contact information plus a field [Employee#] to identify who made that
contact. I want to be able to know which Contacts have been made by which
teams (this occurs on a subform).

Everything works fine, but I can't add a new record from the query mode.
Any ideas?

 

[Pat Hartman\(MVP\)]

Tell us which fields are the primary keys of each table.
Tell us if you have defined a relationship and enforced RI.
Post the query.

I have tblContacts.Employee# in the query. Is that not the "many" side?
How
do I tell?

Select the Join field from the many-side table rather than from the
one-side
table.

I have a query in which one field is joined between two tables. I'm
trying
to enter a new record, but can't enter anything in the field that is
joined.
Is it possible to do this, and if so, how?

Clarification: Two tables, tblTeams and tblContacts. Each table has a
field
[Employee#] which is the joined field. The idea is this: tblTeams has
[Employee#],[First], [Last], and [Team] . tblContacts has many fields
for
contact information plus a field [Employee#] to identify who made that
contact. I want to be able to know which Contacts have been made by
which
teams (this occurs on a subform).

Everything works fine, but I can't add a new record from the query
mode.
Any ideas?