Tom,

Today i've made my first updatable view with macrosubstitution.

just make youre view in the following manner:

CREATE SQL VIEW ... AS ;
SELECT fields, ..., ..., .. ;
FROM Tables.... ;
WHERE &?cWhereClause ;
ORDER BY

THIS should do the trick.

Don't forget to use the DBSetprop command to make the view updatable

good luck,

Walter