Skip to main content
Participant
May 8, 2006
Question

Insert-Update on same page

  • May 8, 2006
  • 1 reply
  • 303 views
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!!!
    This topic has been closed for replies.

    1 reply

    Inspiring
    May 8, 2006
    On your form, include a hidden field that has the original mod level. On your processing page, compare the old with the new and code accordingly.