Unable to Enter Data

K

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!
 
K

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Data disappears on Form and Subform 4
Query with common fields to all records 6
I cannot enter data into a query in access 3
Can't enter data in query datasheet 1
Unable to add record to another realted table 2
Similar function needed to Excel VLOOKUP 2
edit field data in query 1

Top