Hi, I'm using filemaker 3 on a Powermac 7300 under 7.55.

I'm gradually learning scriptology.

I am creating a database, where I can keep track of people and write encounter notes about each person.

For security reasons, I would like to lock the text fields to not allow any modification after a certain time or date (i.e. no field modification on a note about a client after 24 hours or after I click a button shortcut). The field is a text field that I have typed about a client.

I know that this is possible, as I have seen commercial demos with this feature, based on FM3. I can't find a reference as to how to do this.

Thanks in advance. [email protected]

How about having two fields:

TextEntry (text)

TextCalc (calculation, text) = TextEntry

Put the TextCalc field on top of the TextEntry field (make it opaque). Create a script:

If (Date < LockDate) <--- use your own criteria

Go to field (TextEntry)

Else

Go to field ()

End If

Make sure TextEntry is not in the tab order.

-bd