Hi Jeff.

>Thanks Doug. I was looking specifically for an example of build a filter from the "is one of" results. Below is what I have come up with. This is working, but I'm always open for improvement. Is there a better way for me to be doing this?

This is just off the top of my head, but I think you could simplify the code using a loop instead:

loValues = SQApplication.DataEngine.GetValuesForField('Loan.cStatus','is one of')
if loValues.Count > 0
  lcFilter  = 'LOAN.cStatus in ('
  lcCaption = 'Status Is One Of '
  for lnI = 1 to loValue.Count
    loValue = loValues.Item(lnI)
    lcValue = loValue.Value
    if not empty(lcValue)
      lcFilter  = lcFilter + iif(lnI > 1, ',', '') + ;
        "'" + alltrim(lcValue) + "'"
      lcCaption = lcCaption + iif(lnI > 1, ',', '') + ;
        alltrim(lcValue)
    endif
  next
  lcFilter = lcFilter + ')'
... rest of code
endif

>BTW the Stonefield Query help file mentions the following about a SFQ message board. Is this still available?
>
>A message board for Stonefield Query users and developers is available at:
>
>http://www.contactreview.com/mb/postlist.php?Cat=&Board=stonefieldquery

Contact Review went under earlier this year. However, we're switching to a DNN-based Web site in a week or two which has a message board, RSS feed, and lots of other cool new features.

Doug