Jump to content

[FP5] passwords on specific fields


This topic is 6502 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6502 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.