Able to copy, how do I amend a record?

[raghuprabhu]

Hi All,

Wish you all a Merry Christmas and a very safe, Happy and Prosperous New Year!

Attached a small database. The tblMain holds the persons details. secTable holds the commence and cease records. Commence is actiontype 1 and cease is actiontype 2.

I am able to copy a commence record by clicking the button with the caption “Copy to Cease”. I have trouble amending when I click “Amend In Cease”. What I want to do is to amend a cease record if I amended a commence rec ord. Basically I have to write the SQL statement .

Any Ideas would be welcome.

Thank you.
Cheers
Raghu Prabhu

 

[raghuprabhu]

Hi All,

Was able to solve the problem. This method helps the users to copy a record within the same table and amend the first record and then amend the second one at the same time. This method can be used to copy and amend record from one table into another.