artsapimp — Tue, 22 May 2001 14:00:04 +0000

What I ended up doing with the ASP is creating 2 tables for the sale. One is the customer table and the other is an ItemsSold table. The customer form is populated with the customer's information which is the top few textboxes on the form. It then closes that table and opens the ItemsSold table and writes the RecordID from the customer's table into a customer field and then loops all checked items and writes a new record for each of them under the ItemSold field.

It's not the best way to build it if reporting was the most important feature needed, but pulling the data out of the database is #1 for this project so this is the easiest on the server.

...and Yes, I found another site which was doing the redirection from one textbox to another and I taught myself how to do it by viewing the sourcecode, pretty easy!

Thanks for the response.

ShinNathan — Tue, 22 May 2001 02:34:32 +0000

How did you solve the js prob?

As for the asp, I think you will have to use many ifs.
But maybe you could name the checkboxes 1 to whatever and use a loop to check them?..

like:
---------------------------------------------------------
for x = 1 to 50 ' or what ever a for next loop looks like

if request.form(x) = checked then

upload to database
end if

x = x + 1
next
----------------------------------------------------------

Maybe this would work?

artsapimp — Mon, 21 May 2001 18:04:19 +0000

I figured out the javascript portion of my original question. I am still confused about the best way to do the ASP as explained above. Thanks for any help.