Question
Insert-Update on same page
A user filters a specific record based upon the record's name
and modification level and all the info based upon this filter is
then displayed on an edit page. The user can then change any field
except for the record name. Any changes are saved as an update to
the selected record. However, if the user changes the mod level, an
insert statement must be initiated and the changes must be saved as
a new record, not an update to the current record, therfore leaving
the filtered record as is. Any ideas on how to get this
accomplished would be greatly appreciated!!!