>I have a view which is based on two tables - subscriber and money table. The link is on a field call c_id which is in both tables. I need to delete only the record in the money table but not the record in the subscriber table. Is there any way I can do this using this view.
Yes, if the Subscriber is not updatable in the view. i.e., The key field for Subscriber has not been identified in the view.
Mark McCasland
Midlothian, TX USA