Datasheet:edit data with Left outer join to a view

[arduk]

I am using an Access2000 ADP, connecting to a SQL 2000 backend.

I have a datasheet that is based on the sql statement below

SELECT VariousFields
FROM Detail D
INNER JOIN Product P
ON D.ProductCode = P.ProductCode
INNER JOIN Master M
ON D.RefNo = M.RefNo

LEFT OUTER JOIN vw_Customer VC
ON M.ConsumerID = VC.ContactID
where (conditions vary depending upon search criteria selected)

The users want to be able to update the fields in the Detail table via a datasheet.

This was working fine, until I added in the last join - to the view of the customer details. This view pulls data in from another database (we have a central database that stores all of our contact information), so I don't know whether this impacts it at all, or whether the Left outer join impacts it at all?

I have the unique table set to the Detail table. All tables have a primary key.

Looking forward to any assistance that anyone can provide with this - I feel like I'm beating my head against a wall here, as this is a requirement in order for the users to accept the app. If anyone has a workaround then I'd love to hear it.

 

[arduk]

Cancel that - I think that I have it working now - I removed the view, and joined directly to the tables instead, and it seems to be working OK...

Sometimes it just takes writing it down to set you on a new track...

Sorry for any inconvenience!