Query with multiple tables won't let me change data.

C

Chrisso

Hi All

I had a query that joined three tables and I could update data
directly in these tables by editing the fields displayed in the
query.

I added a 4th table and now I cannot edit the fields as described
above. Access will not allow any changes.

Obviously this is due to the extra table and how I joined it to the
others. Can anyone provide me with a checklist of things to look for
so that I can edit the data again as before?

I must need to tweak the join somehow but am not sure where to start.
Does anyone have any pointers for me.

Thanks in advance for any ideas,
Chrisso
 
S

shirley hall

Chrisso said:
Hi All

I had a query that joined three tables and I could update data
directly in these tables by editing the fields displayed in the
query.

I added a 4th table and now I cannot edit the fields as described
above. Access will not allow any changes.

Obviously this is due to the extra table and how I joined it to the
others. Can anyone provide me with a checklist of things to look for
so that I can edit the data again as before?

I must need to tweak the join somehow but am not sure where to start.
Does anyone have any pointers for me.

Thanks in advance for any ideas,
Chrisso
Click to expand...
 

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

Nested query problem 6
Cannot use update query to update records in another query 6
Updating tables when you input new data 0
Query won't let me update child record ?? 1
Child Table With Two Parent Tables 4
Why won't my form allow me to input data? 2
Form not allowing edits 2
Linked Tables 2

Top