ADP UPDATABALE SNAPSHOT PROBLEMS (1 Viewer)

[sbornstein1]

I have a query which is this followed by this. I cannot make updates to the tblOrders fields. I have
set the Updatabale Snapshot and Unique Table properties. What am I doing wrong. I can't update anything
in this? Any ideas. Here is the wuery.

SELECT DISTINCT
tblOrders.*, tblCustomer.CustCode, vwabaordersort.abaSort,
CASE WHEN tblOrders.OrderDate < CONVERT(varchar(11),
getdate(), 113)
THEN 2 ELSE CASE WHEN tblOrders.OrderDate > CONVERT(varchar(11),
getdate(), 113) THEN 3 ELSE 1 END END AS ColorID,
(SELECT DISTINCT DriverCode
FROM tblorderdrivers
WHERE tblorderdrivers.Ordernumber = tblOrders.OrderNumber
AND DriverNumber = '1') AS Driver
FROM (tblCustomer INNER JOIN
(tblOrders LEFT JOIN
vwabaOrderSort ON
tblOrders.OrderStatusCode = vwabaOrderSort.abaCode) ON
tblCustomer.CustID = tblOrders.CustID) LEFT JOIN
tblOrderDrivers ON
tblOrders.OrderNumber = tblOrderDrivers.OrderNumber
WHERE (((tblOrders.OrderStatusCode) IN ('AA', 'AD', 'AP', 'AS', 'RR',
'CB', 'PB', 'RB', 'HD')))
ORDER BY vwabaordersort.abaSort, tblOrders.OrderStatusCode,
tblOrders.PickupDate, tblOrders.VehicleType,
tblOrders.PickupTime, tblOrders.OrderNumber