retrieve form variable through database connection

[minority]

ok

i got a question that i am not sure is even possible

i want to call form object o na new asp page however the form check box names are derived from the database eg the dept_Name.

So on the next page i do a call to the department table and go through each of the dept names to retrieve there value. eg

deptname = rsqms("Dept_Name")
deptform = request.form(""deptname"")

this should get me the form and the value held in that form object is this even possible.

[stevusuk]

are you wanting to drill down to a lower and lower level of detail - so you go from departments, to a department, to individuals, to an individual etc etc (that kind of thing)?

would it be feasible or easier to pass querystring values from page to page or have i missed what you're trying to do?

If querystrings were used you could then use ASP to interrogate the database and return recordset(s) with the details you need to populate your form object - and construct the form object and values etc using ASP.

stevus uk

[minority]

i thought it out and got it working now stuck on sub categories lol.....how do you retrieve field names as i need this to compare something.

basically you can determine which department has which document type so that they do not show up on the menu system i just adding a way of adding new doc type with the ability to add them to departments when it is created.