Update Query on a Linked Table

[goslincm]

I want to join one of my linked tables to another table I created in my database. However, when I try to update the field from the Linked table over to my table, I get an "not updateable error message.

Can this type of update be done?

 

[AlexCuse]

Can you post your query?

Ignorance of certain subjects is a great part of wisdom

 

[goslincm]

UPDATE dbo_localUnitAudit INNER JOIN DelinquentAudits ON (dbo_localUnitAudit.LocalUnitCd = DelinquentAudits.LocalUnitCd) AND (dbo_localUnitAudit.LocalUnitType = DelinquentAudits.LocalUnitType) AND (dbo_localUnitAudit.FiscalYear = DelinquentAudits.FiscalYear) AND (dbo_localUnitAudit.CountyCd = DelinquentAudits.CountyCd) SET dbo_localUnitAudit.ID = [DelinquentAudits]![ID];

 

[goslincm]

Disregard, I found a way around this problem.