Folks,

Guess it's a « classic » topic around here... Have a problem with
updatable queries in ADP (not sure if it's an Access or SQL server
question, hence the cross post).

To start with I was under the impression that the conditions for an
updatable query where

The select list can't include a DISTINCT or TOP clause.
The select list can't include an aggregate function.
The select list can't include a calculated value.
The SELECT statement can't include a GROUP BY or HAVING clause.
The view can't include the UNION operator.

I have the following query that works fine (although it contains
calculated values...)

SELECT     dbo.MyTable.*, 1 AS ldRecCounting, CASE WHEN
ISNULL(ldMyStuff, 0) <> 0 THEN 1 ELSE 0 END AS ldMatchedCounting
FROM         dbo.MyTable

I now would like to join on a second table

SELECT     dbo.MyTable.*, 1 AS ldRecCounting, CASE WHEN
ISNULL(ldMyStuff, 0) <> 0 THEN 1 ELSE 0 END AS ldMatchedCounting,
                     dbo.qActivePOL.POKUNN AS ldNEWField
FROM         dbo.MyTable INNER JOIN
                     dbo.qActivePOL ON dbo.MyTable.ldNoPolIdx =
dbo.qActivePOL.Idx

This new view works fine but is not anymore updatable (note that I do
no want to update ldNEWField, I just need it for display purposes).

Is there a way around this ?

Thanks & regards

-alexT