Kaiden Posted September 11, 2006 Share Posted September 11, 2006 I've recently built a database in FileMaker 6 and I wanted to know if there is way to lock a field after data has been entered into it. I would like to prevent someone from changeing the data in that field. Link to comment Share on other sites More sharing options...
efen Posted September 11, 2006 Share Posted September 11, 2006 See attached file -- the present field in the current record is locked when a new record is created lock.zip Link to comment Share on other sites More sharing options...
agtjazz Posted September 11, 2006 Share Posted September 11, 2006 or try this Link Link to comment Share on other sites More sharing options...
Kaiden Posted September 12, 2006 Author Share Posted September 12, 2006 Thanks for the help. The lock calculation work great on several of the fields I needed to have locked. However, I also have a set of repeating fields that won't take the calculation. Is there a calculation that will allow me to lock repeating fields? What I've done is set up a form that will allow a person to enter data into two fields. The first field contains a date and the second field is setup for project notes. I used repeating fields to allow the user to be able to add notes on a daily basis. I would also like to be able to lock the previous notes so the person is forced to created a new one rather than go back and alter an old one. Link to comment Share on other sites More sharing options...
bruceR Posted September 12, 2006 Share Posted September 12, 2006 Yet another reason not to use repeating fields. You need to set up a table (file) of project line items. Each record can be locked independently. Link to comment Share on other sites More sharing options...
Kaiden Posted September 12, 2006 Author Share Posted September 12, 2006 Thanks for the help. I looked at tables for project line items, but it didn't add the functionality I needed. The repeating fields work. I was just looking for something a little more efficient. Thanks again. Kaiden Link to comment Share on other sites More sharing options...
T-Square Posted September 12, 2006 Share Posted September 12, 2006 "but it didn't add the functionality I needed" It seems to me your initial request indicates that you DO need this functionality. A separate notes table is more efficient, especially in light of the fact that you want the notes locked up after entry. You can easily set your user interface so that your users only have to type in an empty line on screen to add the new note. A read-only portal would give them the ability to view the history... Link to comment Share on other sites More sharing options...
bruceR Posted September 13, 2006 Share Posted September 13, 2006 As - Tsquare mentions, line items DO provide exactly what you asked for and what you can't get with repeats. You can't individually delete repeats. You can't sort them. You cannot report on them. For instance, look at all the project line items tied to a specific resource or assigned person across multiple projects. How many hours is Sam committed to this month? Oops, can't figure that out with repeats. Link to comment Share on other sites More sharing options...
Kaiden Posted September 27, 2006 Author Share Posted September 27, 2006 Thanks for the suggestion. I will have to go back and take a look at this. Hopefully it will work in FileMaker 5.5 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6512 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now