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