Topic Options
Rate This Topic
#137366 - 04/16/07 10:52 AM Access Group
siocco Offline
Stealth Member

Registered: 01/04/07
Posts: 13
hello. I am trying to compare 2 access group field on 2 forms in a push fields if statement. Currently I ( $Access Group$ LIKE ( "%"+'Access Group' + "%" )). This does not produce reliable results when the one access group is for instance ABC and the other is ABC DEF (2 groups). Any help is appreciated.
Thanks

Top
#137376 - 04/17/07 03:46 AM Re: Access Group [Re: siocco]
Shark_7-11 Offline
Stealth Member
*****

Registered: 09/26/06
Posts: 267
Try comparing Group ID's instead
To search for a group, it can be one of two ways
It's either first in a list of groups:
'Group;%' Notice that there is no ';' in the front here
or it's NOT the first
'%;Group;%'
In a nutshell: (Group Like 'X;%' OR Group Like '%;X;%')
I hope this help
_________________________
Mayhem, Chaos and Anarchy
My job here is complete!

Top
#137380 - 04/17/07 03:59 AM Re: Access Group [Re: Shark_7-11]
Vincent_RIEDWEG Offline

Old Hand
****

Registered: 05/24/05
Posts: 1454
Loc: France
It it possible for your requirements to use the Application-Confirm-Group process in a loop?
_________________________
Vincent.

Top