Locking A Field

[Kaiden]

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.

[efen]

See attached file -- the present field in the current record is locked when a new record is created

lock.zip

[agtjazz]

or try this Link

[Kaiden]

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.

[bruceR]

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.

[Kaiden]

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

[T-Square]

"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...

[bruceR]

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.

[Kaiden]

Thanks for the suggestion. I will have to go back and take a look at this. Hopefully it will work in FileMaker 5.5