I am currently building a database in FileMaker 6 and I have created a Layout with a repeating field. Is there a script that would allow me to restrict the information entered into the field? For example the field repeats 10 times allowing the user to enter data each time. I would like to lock the field after information has been entered. To be more specific once the user enters data into a field they can not change it and will have to go to the next field.

Hopefully this paints a decent picture of what I am trying to do. Can anyone help me?

Thanks,

Kasei

To restrict access to the field simply don't allow the field to be entered. Create a global field to hold the data and use a script to enter the data from the global into the actual field.

Forgive me for making this difficult, but how would I restrict someone from entering data into the field and what script would I use to pull the data in from the global field?

Thanks for your help in advance.

Edited April 4, 200619 yr by Guest

You'd be much better off using a portal and related file instead of the repeating fields.

To disallow entry into a field, go into layout mode, select the field, choose Field Format from the Layout menu, and uncheck "allow entry into field".

Thanks for the information.