Hi Andy,
I think you have to use the database name and not the label in EXTERNAL
qualifications.
Kind regards
Norbert
Mayfield, Andy L. schrieb:
**
I am trying to have a table populate based on a drop-down field
selection.
I have created a temp field (zTmpHiddenTableQual) to hold the
qualification statement.
This field gets set by an active link that fires when making a selection
from a drop-down menu.
The active link is firing and the qualification statement is getting set
into the temp field.
The second action on the active link does a change field that refreshes
the table.
I have the table properties qualification set like this: EXTERNAL(
$zTmpHiddenTableQual$)
The value in the zTmpHiddenTableQual field does contain a valid
qualification statement, but the table is blank.
The value in the zTmpHiddenTableQual is : '*Assigned Group' =
"SIA_Config", which if pasted in the advanced qualification bar for the
referenced form returns the values as expected.
I thought I was setting up the way the documentation descibed, but I
obviously an missing somthing.
ARS 7.0.01 P002
Windows 2003
MS SQL
*Andy L. Mayfield*
*Sr. System Operation Specialist*
*Alabama Power Company*
*Office: 205-226-1805*
*Cell: 288-9140*
*SoLinc: 19140*
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
