I have a form that list multiple divisions in a drop down list. I want to be able to assign the department to the division without having to ask the user to select the department.
My SQL statement might look something like
Select Lname, Fname, SSN From Personnel Where Division='::Division::' and Dept='::varDept::'
I will use VBScript to create the varDept entry but I cannot figure out how to pass the variable to the sql statement. Any ideas?