Preventing field access on 'closed' records
I am a volunteer working on a database for a non profit organization offering transportaion services for medical purposes & meals on wheels etc.
Each record has fields including Customer name, Volunteer name, destination, miles travelled , cost of service & so on.
Once the service has been done and paid for it is 'closed' ( in a status field )
I need the information available for statistics purposes but I would like that it be impossible to make changes to any of the fields and also impossible to duplicate the entire record once it is closed.
I am a beginner if filemaker and would appreciate any help you can give me.