Can I lock records for closed jobs?

[GeorgeMack]

I have a series of related databases, for projects(jobs), clients, and timesheets. I would LIKE to click a button in the projects file and lock all timesheet records relating to that project in the timesheet file (so I don't wind up entering more time on a closed job.) I just can't seem to find a way to do this.

Maybe Lock isn't the right word; I don't want records of closed jobs to be casually modified, but user-level is too global to screen out by job status.

Any ideas, hints, or references? (All files on one machine, with one user, me.)

[DykstrL]

I emailed you a file that provides a method to do this. Hope it helps.

[falkaholic]

The way I'd do it is to make a new field to store weither or not the job is still active. Make a button the runs a script to set the value.

Then in any calcs you check to see what the field is and take approprite action.

[Vaughan]

Dulpicate the layout, but change all the fields not to allow entry. Script the navigation and use this "locked" layout when the "locked" field is checked.

[Steven H. Blackwell]

Simple number field, auto-enter value of 1 on creation.

Validate all fields against that field.

When the record is to be "locked" set the field with a 1 in it to be 0.

Then no field that validates against that field can be changed.

HTH

Old Advance Man