Unable to Enter Data

[KKash]

I have set up a Query based on 2 tables with different information however
linked by one field that is the same (an ID Field). However, one of the
tables has housed information already and the other table is information that
is added a little at a time by Data Entry. The problem is that I'm unable to
enter data. What I type does not show up in the fields. Do I have my
relationships set up incorrectly? Or is there some other Access thing that
is keeping my data entry from not showing up? Thanks!

 

[BruceM via AccessMonster.com]

When a query contains two linked tables, for some fields Access does not know
which record you mean to change. For instance, what is your intention when
you try to change a field in the parent table? That data is part of a single
parent record, but it will appear with every child record in the query, so
Access does not know what you intend by changing it in one place. For that
reason at least the entire query is read-only. While it would be OK to
change some of the fields, Access does not create a partially editable query.
That's not how it is designed to work.

The way around this (and the best way in any case) is to build a form based
on the parent table (or on a query based on the parent table), with a subform
based on the child table or query. The link properties of the subform
control (the box on the main form containing the subform) are set to the
linking field.

If I have misunderstood, here are some reasons a query may be read-only:
http://allenbrowne.com/ser-61.html

 

[KARL DEWEY]

I have set up a Query based on 2 tables with different information however
linked by one field that is the same (an ID Field).
Do you have a relationship set between the two tables? Is it one-to-many
with Referential Integerity and Cascade Update?

 

[Dale Fye]

Some queries just are not updateable. Check out Allen Browne's explaination
at:

http://www.allenbrowne.com/ser-61.html