OWS questions. I am using a new insert query which is supposed to pull a value using a Select statement instead of using a form variable and it doesn't work. Does anyone know how something like this should work? Do I assign a new variable, and where does it go? INSERT INTO joblists(System,Job,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Alert_Time,Next_Day,Comments,GroupID) VALUES (@System,@Job,@Sunday,@Monday,@Tuesday,@Wednesday,@Thursday,@Friday,@Saturday,@Alert_Time,@Next_Day,@Comments,Select GroupID FROM ncn.BSA.Systems WHERE GroupID = [frmSystem,form])

mfnc @ ows forums was kind enough to answer my questions. To view the working input statement you can go to this URL. http://www.openwebstudio.com/Commun...fault.aspx Basically I had to declare a new variable in my input statement and use this to add the groupid instead of the normal OWS assigned variable.

thanks for posting the info,