Does anyone have a suggestion on how I can make a record "invisible" to certain level users after they have entered it? Specifically, a user signs in, is taken to the entry layout, inputs into 8 or 9 fields, then chooses "complete" from the status field. Upon choosing "complete", I want them to no longer be able to access the record (not even to read- it should "disappear"). The VPs who will handle the case will have access but regular users will only be able to enter into new records. (Medical field, sensitive data, etc., etc.) Thanks to any suggestions!

Anna

see Help, topic record based security in Filemaker 5.5 and higher ...

if (complete ="complete" and CreationDate <> Status(CurrentDate), 0,1) would limit record access to todays entries ..

In older FileMakers, you can simulate this by using portals only for record entry ...

Thanks- I looked at it and I think I can modify the calc to use a "flag" field instead of user or date (I can't limit access by those criteria). I was trying to get to my nose by going around my elbow- I should've known the solution was in front of me! Again, thanks.

Platform: / Version:

FileMaker Version: