Is there a way to lock entire records?
Is there a way to lock an entire record (and it's related records)?
I would like to be able to lock a record (and it's related records) after a job is closed so that users cannot accidentally (or on purpose) make any modifications to closed jobs. Also, is there a way to lock the records for some users and allow modification by other users based on user name and privileges sets? I will need detailed instructions for how to do this with privilege sets as FM10 does this so much differently than FM5 and I am still on a learning curve.
We are using Filemaker Pro 10 Advanced and Filemaker Server 10 Advanced. Filemaker Server Advanced is running on a Windows PC server. We have about 25 Filemaker client users (both Mac & PC). We also have non-Filemaker client users for employees company wide to access a couple of layouts via Custom Web Publishing. Our company has been using this Filemaker database since 1998. I personally have been using Filemaker since the late 1980’s when it was called Claris Works. We just recently upgraded from Filemaker 5 to Filemaker 10 and are in the process of a major overhaul of the entire database. Records in the main table represent individual marketing jobs (usually print jobs - i.e. brochure, forms book, mailer, etc.). Then, we have about 18 related tables for tracking various aspects of a job through the production schedule, from job initiation to completion. It tracks milestone due dates, design specs, licensing information, inventory, distribution, costs, etc.