Overtype value in form and create new record in table

S

Snowsride

I have a table that stores records that each have an effective and inactive
date. A current record has a null inactive date.

I want a form that shows the current values for each record BUT I want the
user to be able to overtype the displayed value and then save the record.
When the record is saved it should set the current record's inactive date to
sysdate and create a new record with an effective date of sysdate and a null
inactive date.

Help appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top