Eli, Have you tried to put the double quotes within double quotes??? That has worked for me.. Write to me offline if you still cannot figure how to include those double quotes before and after the $col_name$..
Joe ----- Original Message ---- From: Eli Schilling <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, April 5, 2007 3:24:18 PM Subject: HELP - Building EXTERNAL table qual using table loop ** So I need to build an EXTERNAL qualification using a table loop. When the user opens a form there is a hidden table that looks to another form to determine associations. The table loop builds a list of these associates into a qualification (i.e. ['Manager*' = $col_MgrName$ OR 'Manager* = $col_MgrName$...] etc) and sets a field with this value. The EXTRNAL qual on the table then grabs this field. The problem is I can't get double quotes around the column value. So I end up with 'Manager*' = Steve Smith...and of course without the double quotes the qualification fails. Can someone tell me what I'm missing? I have tried: "'Manager*' = " + $col_MgrName "'Manager*' = " + """ + $col_MgrName + """ "'Manager*' = " + """"" + $col_MgrName + """"" Thanks in advance! Eli ____________________________________________________________________________________ TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV. http://tv.yahoo.com/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
