Jump to content

Freeze an invoice


This topic is 7163 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

I have a question, I am making a database with an invoice system.

Users should be able to change the invoice, but at a certain moment (when they push a button or when something else happens) The invoice should be frozen, people shouldn't be allowed to change it nomore. What is the best (easiest) way to do this?

Should I just direct them to another layout where no fields can be changed or are there better ways to do that?

Hope someone can help me,

Thanks anyway,

Greetings,

Thierry

Link to comment
Share on other sites

Have a number field called "Lock" with auto entered value of 1. Have all fields in the invoice validate against that "Lock" field. When you are ready to lock the invoice, have that field change to 0. Thereafter no field validating against it can be changed. This is the essence of the Boolean test for validation.

HTH

Old Advance Man

Link to comment
Share on other sites

This topic is 7163 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.