Hidding a record...

[Addam]

Is there a way to actually hide a set of records bassed upon the password entered?

I mean, have it not show AT ALL when performing a find or showing all the records?

~Addam~

[RueWilson]

I'm actually in need of this as well. I need to be able to hide entire sets of records based on the individual user's password.

[Kurt Knippel]

You need to have something that defines what records they can see.

For instance, let's say that you have a field called Access level and it will be a number between 1 and 5 (highest level).

You then need to define all of your finds to include a calculation into the Access Level field based upon the users password.

For example, the Set Field calculation (in Find Mode) might be as follows:

code:

---

Case (

Password = "Lowest", "== 1",

Password = "Low", ">= 2",

Password = "Normal", ">= 3",

Password = "High", ">= 4",

Password = "Highest", "",

"== 99"

)

The last part there is so that if the user entered with an invalid password the finds will never return any records.

You could also do this with record level access if using Filemaker 5.5 and above, but it just makes the records unavailable or uneditable but still shows them in the finds and could confuse users.