Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How do I stop additional data entry to a record?

How do I stop additional data entry to a record?

How do I stop additional data entry to a record?

I have a database that is used to monitor maintenance callouts to various buildings, these records are classified as either 'open', 'pending' or 'closed' from a drop down field menu. When the field is changed to 'closed' how can I prevent all the rest of the data in the record from being modified?
Many Thanks,

RE: How do I stop additional data entry to a record?

There is no right or wrong way to accomplish this.  Depending on how much flexiblity you want will determine what is best for you.  The quick down and dirty way would be to use FM built in security.  Go to Manage - Accounts and Privileges.  What you need to do is create a new privilege set.  Assign it a name and then on the Records drop down choose custom.  You can then set the access levels for each table in the database and for edit select limited and you can build the expression for when it is ok to edit.

Then simply create the users and assign them this set.

Alternatively, you could use scripting to change the field to closed, and use separate layouts where the fields can not be entered in the "closed" layout.  You can get pretty creative with using different portals and relationships to display the data differently depending on the "status".

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close