Congo,
You want your zTmpQual field value to look like the following when your done:
'1'="000000000000001" OR '1'="000000000000002" OR '1'="000000000000006" .. (etc)
The way to do this is....
Before you call the guide. Clear the value of the zTmpQual value.
In the guide...
if the zTmpQual = NULL... then
zTmpQual = "'1'="""+$column_Value$+""""
else
zTmpQual = $zTmpQual$+" OR '1'="""+$column_Value$+""""
That should get you where your going.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 4/16/07, Congo <[EMAIL PROTECTED]> wrote:
Thanks Dylan,
But I still cant figure it out how to fill the table B.
Each loop on Table A the zTmpQual gets something like: "('490008000'=
$TableAColumn$)"
So at the end of the guide I got a value form the last table A
record.
It results that Table B holds only record related to this last record.
How to get all of related records?
On 15 Kwi, 09:16, "Wheeler, Dylan" <[EMAIL PROTECTED]> wrote:
> Second part is fairly easy. Create a display only hidden field, name it
> whatever zTmpQual. Build your qualification with the AL guide loop into
> that field. The Table B qualification will be EXTERNAL($zTmpQual$)
>
> Second thought on the first part, if the AL Guide is giving you the last
> ID then make sure your adding it to a field and not overwriting. One way
> to check is to pop up a note message on the beginning leg of each loop
> with the ID.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
