Off the top of my head, I think that you do a direct sql that would return the same results that the table would and then do a set field command using the value of lastcount. I think that would give you a number and you can build workflow to check if the value is greater than 0. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701
>>> [EMAIL PROTECTED] 05/30/08 8:44 AM >>> I'm trying to check to see if a table has any rows in it, but i'm not having much luck. I have tried to check for the table NOT being NULL and I have check for a column NOT being NULL, both do not work. I'm looking to see if the Relationship table is NOT NULL - so I tried: 'z2TH Associations' != $NULL$ (this is the table name) I also tried: 'z2TF AssociationType' != $NULL$ (this is a column name) Both of these do not work. However, if I remove this qualification my workflow works. Any ideas why I can't check to see if there are any rows in the table? THANKS! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

