Andy, A qualification that works in the Advanced Search bar doesn't work with External.
If I remember correctly the whole statement must be enclosed in double quotes. I don't have my laptop connected up at the moment so I can't give you an example. Dave -------------------------- [EMAIL PROTECTED] (Wireless) ----- Original Message ----- From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Sent: Thu Oct 04 18:06:31 2007 Subject: EXTERNAL command problems ** 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___