Thank you for your post.
With Accounts and Privileges, you can set a user to have the ability to add records, but not edit or delete them. This way, once the record has been added, no changes can be made to that field (or fields).
If you need clarification how to do this, please let me know.
TSGal i would love clarification how to do this. Any help would be awsome.
In accounts&Privileges, under records, choose "custom privileges..." This will pop up a window with many various selections. Choose the table you want to restrict and choose "limited.." under the EDIT header.
A calculation window will pop up in which you will describe the conditions under which someone can edit the record.
Assuming you have a field with the date after which the record should not be modified, the calc can take the form of:
Get(CurrentDate) < Table1::LockOutDate
or something like:
Get(CurrentDate) < (Table1::CreationDate + 15)
You'll need to determine how to describe the lockout criteria to meet your needs...after that, it should be pretty direct.
Keep notes, playtest it yourself before launching, always keep backups... ;)