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...
 
Top