Versions?? Earlier versions of 7.5 had problems with conditions on things like Search Menus, Join form qualifications, and I think table fields too, when one of the fields referenced in the qualification was not from the current table..
There is a workaround for that if what you are on is that earlier version.. I had that problem with Search menus and I figured out a workaround to get around it.. For the purpose of being able to save, choose a field on form a within that LIKE operator parameters, save,, export to XML def file, edit the XML def file, and then change the form name and field id to be form b and that field from form b.. Import it.. Joe From: Chowdhury, Tauf Sent: Tuesday, September 13, 2011 2:46 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Correct way to use LIKE operator and wildcards in table qual ** All, I’m trying to either build an external qualification or just directly in the table qual itself, a string that will look something like this. ‘Field1onFormA' LIKE "%$Field1onFormB$%" OR ‘Field2onFormA’ LIKE "%$Field2onFormB $%" I received an error so I tried something like this below but still received an error: ‘Field1onFormA' LIKE "%” + $Field1onFormB$ + “%" OR ‘Field2onFormA’ LIKE "%” + $Field2onFormB $ + “%" Can someone guide me in the right direction? -------------------------------------------------------------------------------- This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"