Is there any mean to prevent modifing table recorders older than 12 months ? while recent records remain avaialambe for modification.
You could set up a lock expression inside the privilege set options that compared the current date to a date field in the record. Something like:
( get(currentDate) - dateField ) < 365
Thank you can explain more !! i can see if it will lock a part off table data and not all table data !
I am going from memory here as I don't have FMP open at the moment.
Open Manage Security
Select an account and edit its privilege set.
Select Custom Privileges from the records drop down.
Select the "Limited" option for editing this table.
This opens a dialog for entering the calculation.
Retrieving data ...