Peter,
Yes, it will add any records you add to the view to the base table.
>John,
>Thanks again it worked fine, one last request for info today, if you add records to a view and issue a tableupdate will they be picked up by the SQL update and update the base table?