Hi

I'm designing a database for school kids. I have 2 sets of number fields on one layout. 1 set is for info on the present school, the other for info on the new school. When a kid moves school I input a date left. I want to design the database so that if a date left has been entered the first set of number field can only be accessed with a password inorder to prevent entering the new school data in the old school fields.

is this possible?

FileMaker Version: 5

Platform: Windows XP

Giles:

Yes, it is possible, but how you do it depends on how you navigate through your solution. The best thing to do is to have two nearly identical layouts, one of which is editable, the other of which is not (i.e., in Field Format, uncheck the "allow data entry" box for the fields you want to lock.) Have a script which brings you to your entry screen, and in that script you can check the "Date Left" field with the following:

If ["IsEmpty(Date_Left)"]

Go To Layout[Your_Editable_Layout]

Else

Go To Layout[Your_Locked_Layout]

End If

-Stanley

Great that works perfectly

giles