Record Set not updateable

[Nick Bradbury]

Hi

I have a query to display the amount to be invoiced for work done, however
the result returned is not updateable and I want to add a field to enter
money received in payment. The tables concrned are linked in the following
way

tblCompany - 1 to Many with tblLabOrders and tblCustomerPrices
tblLabOrders - 1 to Many with tblLabSamples
tblCustomerPrices - 1 to Many with tblTest Suite



SELECT tblLabSamples.LabSampleID, tblLabSamples.LabNo,
tblCompany.CompanyName, tblLabSamples.SampleNo, tblLabSamples.CustomerRef,
tblLabSamples.Description, tblLabSamples.Quantity, tblLabSamples.DateOnTest,
tblLabSamples.Status, tblLabSamples.DateCompleted,
tblCustomerPrices.CustPrice, tblLabSamples.CloseDate,
tblLabOrders.CompanyID, tblLabOrders.Invoiced, tblTestResult.TestSuiteID,
tblTestSuite.Description
FROM (((tblCompany INNER JOIN (tblTestSuite INNER JOIN tblCustomerPrices ON
tblTestSuite.TestSuiteID = tblCustomerPrices.TestSuiteID) ON
tblCompany.CompanyID = tblCustomerPrices.CompanyID) INNER JOIN tblLabOrders
ON tblCompany.CompanyID = tblLabOrders.CompanyID) INNER JOIN tblLabSamples
ON tblLabOrders.LabNo = tblLabSamples.LabNo) INNER JOIN tblTestResult ON
(tblTestSuite.TestSuiteID = tblTestResult.TestSuiteID) AND
(tblLabSamples.LabSampleID = tblTestResult.LabSampleID);


Any ideas on how I can resolve this

Nick

 

[Tom Wickerath]

Hi Nick,

Is your query updateable? If not, have a look at Access MVP Allen Browne's
web page, here:

Why is my query read-only?
http://allenbrowne.com/ser-61.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________