Resolved using field 5001 with a couple of active links.
laaaaavely jaaaaably
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: [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. __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"
