AL#1 Set z_QueryField to NULL
Call Guide and ensure you check the "Table Loop" and select the table to use. Refresh other table field AL#2 IF z_QueryField = $NULL$ z_QueryField = (<qualification> = 'col_Department') Else z_QueryField += OR (<qualification> = 'col_Department') should work like a champ Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 501 6310 Fax: +1 408 501 2410 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frex Popo Sent: Wednesday, December 20, 2006 5:46 AM To: [email protected] Subject: Searching a form using values from a table field ** Hi everyone, 1. I have a form with a field department which takes a value (department) from a SQL query and use it to run a serach. 2. A User wants to see more requests (e.g from another department), so I need to set the department field to one, two or more values representing # departments. 3. I have created a table field with one column which (on open window/dispaly) will hold all the department names read from a different form. What I need now is how to catenate all the entries (department names) in the table (if the user belong to more than one) in one value and set it to the department field and run a serach base on this. Is there a way to do this without using active link guides and active links to walk through the table? Regards frexpopo ________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses <http://fr.rd.yahoo.com/evt=42054/*http:/fr.answers.yahoo.com> . __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
