If the view was designed to accept new inventory records and submit updates to the inventory table, I would append to the view. Otherwise, you have to append to the inventory table or modify your view.

I would not close the view. I would just issue a requery on the view. Of course you have to issue a Tableupdate on the view if it is updatable to save any changes made prior to the new record.

>I've created a form that uses a view in the D.E. made up of 3 tables: inventory, customers, and transactn. On the form is a dropdown linked to a field in the view called Stocknum, which is the primary from the inventory table.
>
>In the interactivechange event of the dropdown is a procedure that finds the record in the view with the value selected in the dropdown. The appropriate data from that record is then output to other objects on the form.
>
>I want to add a new record to the inventory table. Since the view is made up of fields from 3 tables, and I want to append to only one...
>
>1. do I need to close the view and open the inventory table in order to append? How would you best do this?
>
>2. What effect would appending to the view have, since only data for the inventory table would be entered?
>
>
>Thanks
>JD