Jump to content

Access to Records containing a certain character


cpatubo

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

Recommended Posts

Hello, I'm a newbie, be gentle. smile.gif

I'll admit, I have a pretty messy FMPro 6 file, since the client's needs change every week, and I've unfortunately made a lot of "band-aid" fixes instead of making a nice, neat database.

Anyways...

I am trying to accomplish a seemingly simple task: to restrict access to particular records, according to the information in a particular field. More specifically, this client uses manually-entered job numbers that end with one alpha character to indicate salesperson (not the most efficient way to work, but they've been doing this for years and don't really want to change it). They are hiring an assistant for one salesperson that they only want this person to see jobs by this salesperson only.

For example: Job numbers 3000C, 2000C and 2500C belong to this salesperson. Numbers 1000J and 1500V do not. We want the assistant to only access records with job numbers ending in "C".

I was trying passwords privileges, but couldn't figure out what kind of calculation to use under "Browse Records:" (if this is the right place to do it).

Is this even possible, the way we have it set up? Help!

Link to comment
Share on other sites

cpatubo said:

not the most efficient way to work, but they've been doing this for years and don't really want to change it

You just have to hope that in the next following years, they won't hire that much salesmen.

Or already set it to find the last 2 Text characters, starting from "-A" and ending "ZZ"

PatternCount(Status(CurrentGroups),Right(

Substitute(Substitute(Substitute(Substitute(Substitute(

Substitute(Substitute(Substitute(Substitute(Substitute(

SaleNumber,"0",""),"1",""),"2",""),"3",""),"4",""),"5",""),"6","")

,"7",""),"8",""),"9",""),2))

Is there a more elegant way ?

mad.gif

Link to comment
Share on other sites

This topic is 7571 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
×
×
  • Create New...

Important Information

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