Restricting access to certain records.
Is there a way to restrict users from accessing certain records?
Is there a way to prohibit modification of records that are closed?
Is there a way to make it so that users (project managers) could only modify records (projects) for their projects and prohibit project managers from modifing other project managers projects?
BACKGROUND INFO: 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, companywide, to access a couple of layouts via Custom Web Publishing. The client 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, ordering, etc.