Chintan, Your solution worked! Thanks a bunch. I never thought that just switching around the 2 fields would have made a difference. Roney, thanks for all your help too. I appreciate it.
Brooks Chintan Shah-2 wrote: > > How about this > 'Full Name' LIKE ( $Requester Name+$ + "%" ) > > > brooksm <[EMAIL PROTECTED]> wrote: > Roney, > $Requester Name+$ LIKE ( 'Full Name' + "%" ) is one that I tried and > couldn't get the right behavior. I double checked the QBE Match field on > the > 'Requester Name+' field and it is set to Leading. > Just so you know, using the solution above still gives me the same result > as > $Requester Name+$ = 'Full Name' > > Any other ideas? > > Thanks > Brooks > > > Roney Samuel Varghese wrote: >> >> Dear Brooks, >> >> The first set field should contain Requester Name+ LIKE 'Full Name' + "%" >> if >> there is a match then use first matching request or else display a list. >> Hope this helps >> >> Also the requester name field should have a leading database search. >> >> Regards, >> Roney Samuel Varghese >> >> >> On 6/25/07, brooksm > wrote: >>> >>> Hi- >>> I'm trying to create the same kind of workflow that occurs on the >>> Requester >>> Name+ field in Help Desk (but without the AL Guides). >>> I've created a new form and I'd like to be able to enter the first few >>> characters of the Requester's Name and hit 'Enter' to pull up a list of >>> matches or populate the Requester Name field with the matching value. >>> I've >>> got the Active link set up fine, but I can't seem to get the 'Set Field >>> If' >>> syntax right. I can get $Requester Name+$ = 'Full Name' to work, but my >>> users really need to be able to do a LIKE search. Can someone help me >>> with >>> the correct syntax? >>> >>> Thanks >>> Brooks >>> -- >>> View this message in context: >>> http://www.nabble.com/Help-with-Active-Link-Set-Fields-Search-Qualification.-tf3979186.html#a11296302 >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> >>> _______________________________________________________________________________ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >>> the Answers Are" >>> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >> the Answers Are" >> >> > > -- > View this message in context: > http://www.nabble.com/Help-with-Active-Link-Set-Fields-Search-Qualification.-tf3979186.html#a11296727 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > > > --------------------------------- > Pinpoint customers who are looking for what you sell. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > -- View this message in context: http://www.nabble.com/Help-with-Active-Link-Set-Fields-Search-Qualification.-tf3979186.html#a11297228 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
