cant edit records when 3rd table is added

[Barry A&P]

I have a query with two tables T_PartNumbers and T_Life the two tables are
joined on a One to One here is a copy of the query

SELECT T_PartNumbers.PartNumber, T_PartNumbers.Description, T_Life.LifeID,
T_Life.OHLife, T_Life.RTLife FROM T_Life RIGHT JOIN T_PartNumbers ON
T_Life.PartNumberID=T_PartNumbers.PartNumberID;

Everything works as expected, when i add info to my OHLife field a new
LifeID is created just like i want.

The problem i am having is i would like to throw in a 3rd table to limit the
records displayed by the query and when i do i can no longer add data to my
OHLife and RTlife fields

here is the query with the third table

SELECT T_PartNumbers.PartNumber, T_PartNumbers.Description, T_Life.LifeID,
T_Life.OHLife, T_Life.RTLife, T_SerialNumbers_AZ.SerialNumber
FROM (T_Life RIGHT JOIN T_PartNumbers ON T_Life.PartNumberID =
T_PartNumbers.PartNumberID) INNER JOIN T_SerialNumbers_AZ ON
T_PartNumbers.PartNumberID = T_SerialNumbers_AZ.PartNumberID;

why does the third table keep me from editing the T_Life

 

[fredg]

I have a query with two tables T_PartNumbers and T_Life the two tables are
joined on a One to One here is a copy of the query

SELECT T_PartNumbers.PartNumber, T_PartNumbers.Description, T_Life.LifeID,
T_Life.OHLife, T_Life.RTLife FROM T_Life RIGHT JOIN T_PartNumbers ON
T_Life.PartNumberID=T_PartNumbers.PartNumberID;

Everything works as expected, when i add info to my OHLife field a new
LifeID is created just like i want.

The problem i am having is i would like to throw in a 3rd table to limit the
records displayed by the query and when i do i can no longer add data to my
OHLife and RTlife fields

here is the query with the third table

SELECT T_PartNumbers.PartNumber, T_PartNumbers.Description, T_Life.LifeID,
T_Life.OHLife, T_Life.RTLife, T_SerialNumbers_AZ.SerialNumber
FROM (T_Life RIGHT JOIN T_PartNumbers ON T_Life.PartNumberID =
T_PartNumbers.PartNumberID) INNER JOIN T_SerialNumbers_AZ ON
T_PartNumbers.PartNumberID = T_SerialNumbers_AZ.PartNumberID;

why does the third table keep me from editing the T_Life

Some queries are not updateable.
See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated