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.)

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

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.

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.

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