Hello, I'm a newbie, be gentle.

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!

Create an access group for each salesperson naming the group the same as the salesperson's letter code. Then assign the groups to the appropriate passwords. The calculation can then be something like:

PatternCount(Status(CurrentGroups)&"

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 ?

This worked beautifully and without a hitch. THANK YOU, Bob!