I've been working on a rewrite of an FM6 solution into FM7, getting all the structural components incorporated, and really have only started looking at the new security features. I would like to be able to have users be able to create records in a certain table, but restrict access so that they could only edit records for, say, 30 days after creation (and after that, they would be "frozen", except to someone with more access). I've been looking at how privileges are set up, and don't see any way to set up a calculation to test for the 30-day limit, as you could with FM6. Is there a way to do this?

Record-level Edit Limit:

DateCreated + 31 > Get (CurrentDate)

Seems to work. I just tested with Time.

Well shoot! The question would be, where do you actually enter the calculation? That's the problem I'm having, I guess. I don't see where, in the accounts privileges, you would enter any calculations.

Figures....I was looking at the field accesss privileges, and jumped to the hasty conclusion that all the others were similar. But while field access either allows you to edit or not, the record editing privileges have an option that brings up a calculation editing box. Sheesh. Thanks, Fenton!

I should have guessed, from the simplicity of the calculation, that you were really asking "Where?" not "What?"