RE : Re: Searching a form using values from a table field
Resolved using field 5001 with a couple of active links. lavely jably Robert Molenda [EMAIL PROTECTED] a écrit : ** 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: arslist@ARSLIST.ORG 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. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ - Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Searching a form using values from a table field
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: arslist@ARSLIST.ORG 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
