Don't feel bad, Brooks - that's one we've all tripped over. Rick Cook
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of brooksm Sent: Monday, June 25, 2007 4:07 PM To: arslist@ARSLIST.ORG Subject: Re: Help with Active Link Set Fields Search Qualification. 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-Qualif >>> ication.-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-Qualific > ation.-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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"