I have a multi-user data base.

My problem:

Two users are logged on and using an input form based on an update view. The one user is typing in and appending new records to a grid. The second user selects an option to use existing records as a template to fill in their grid and change as necessary. Both users close the form which fires a table update. The first users entries are somehow replaced with the records of the template from the second users selection and the second users entries append just fine.

Any ideas? Isn't a view private to an application instance?