I'm not sure you understand the concept of views...basically you add/delete/edit your view. Not the tables. A paramterized views simply returns a limited recordset from the source...and it's paramterized so the condition can be changed and the view requeried to meet the new condition.

>When we add a new record can we use a parametrized view to come up with an empt view which I can populate then and use it to update records(add new records) to the corresponding base table.