Restrict forms edition

[syedadnan]

Regards,

How to restric forms entry to be restricted from second edits .. means if some one posted single entry one time and wanted to post second edited entry i need form to ask passoword. or not to be updated if not available the password option.

 

[Drunkenneo]

In that case i would be maintaining a audit table, which have records of PK of edited records and counter of number of times edited on PK. From there you can check if the PK counter is 2 then ask for password. But why you need to have password for 2nd time editing only?

 

[syedadnan]

Fine but looking to lock by password the second time edition as it is requirement from my boss.

 

[syedadnan]

In that case i would be maintaining a audit table, which have records of PK of edited records and counter of number of times edited on PK. From there you can check if the PK counter is 2 then ask for password. But why you need to have password for 2nd time editing only?

Fine but looking to lock by password the second time edition as it is requirement from my boss