A
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?
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?