Overwrite protection for fields

[George from Pittsburgh]

I need to protect certain fields from being overwritten once data has been added.

This is for a solution where certain medical information must not be alerted, once entered.

Any thoughts?

Edited September 1, 2005 by Guest

[George from Pittsburgh]

In answer to my own query, if I make a field a button and attach the script;

If Field A <>"

Show Custom Dialogue ["No re-entry allowed."]

exit script

else

Go to Field A

End if

it works fine except if the field repeats. I can't apply the script to other than the first value and then with what seem to be unpredictable results.

Any thoughts?

[esegal]

Why not duplicate the layout and set all the field behavior so that none of the fields are accessible. You could also make a duplicate layout of merge fields. When someone makes a NEW record you go to a record for entry. If you go to REVIEW your records you would see the inaccessible layout. Only the administrator would have permissions to access the data entry layouts.

The script solution might be easier, but I thought I'd throw out an alternative.

[T-Square]

George--

You mention repeating fields. Get rid of them. Repeating fields are not a very manageable aspect of Filemaker.

You should create a related table to hold your repeating information. The related table would have a separate record for each entry in the repeating field. It would have a field that stores the parent record ID, along with fields to hold the individual entries. You'd have a relationship from parent to child, and a layout with a portal to view the information.

esegal's solution is probably an easier and more secure method, and would also work well with the structure I mentioned.

HTH,

David