Linked Query not Updateable

[aMack]

I have been running a query which links 3 Tables. The data has been updateable.

When I add a 4th table the data is no longer updateable.

Main Table: "Inventory In"
Linked Query: "Consignee" [Consignee Name] linked to "Inventory In"
[Consignee]
Linked Query: "Bill to" [Bill to Name] linked to "Inventory In" [Bill to]

New Linked Query: "Origin" [Origin Name] linked to "Inventory In" [Ship From]

All Links are: All records from "Inventory In" and only matching from queries.


What and where do I look to allow the data to be modified?

 

[Golfinray]

Your table is probably not updateable. Check to see if it has the arrow and
asterisk highlighted at the bottom.

 

[John W. Vinson/MVP]

I have been running a query which links 3 Tables. The data has been updateable.

When I add a 4th table the data is no longer updateable.

Main Table: "Inventory In"
Linked Query: "Consignee" [Consignee Name] linked to "Inventory In"
[Consignee]
Linked Query: "Bill to" [Bill to Name] linked to "Inventory In" [Bill to]

New Linked Query: "Origin" [Origin Name] linked to "Inventory In" [Ship From]

All Links are: All records from "Inventory In" and only matching from queries.


What and where do I look to allow the data to be modified?

In general, the more tables you add the less likely it is that a query
will be updateable.

Why are you trying to update a query directly? If you instead base a
Form on the Inventory In table, you can use combo boxes on the form to
display the Consignee, Bill To, and Origin fields while storing the
foreign keys.