AnsweredAssumed Answered

Is there a way to lock entire records?

Question asked by CarlaS on Nov 30, 2009
Latest reply on Dec 1, 2009 by CarlaS


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.