Hey, how's going? I'm having a problem with an E-Commerce website. Basically when the users decide to buy the products and they get into the Orders page they fill in their details and the information gets into the table Customer in my Access database, but the problem is that I'm using session variables to read the order_number from GetOrderID table (which is set to number and NOT autonumber), store it into a session variable, increment it by one each time, assign its value to an hidden field that gets submitted then as CustomerID onto the Customer table.
This isn't working.
At the moment it's inserting the records (name, surname...) but it's not inserting any number onto the CustomerID column. It keeps displaying always the same number with the same customers details.

Any idea??
Please any help would be very much appreciated.

Thanks,
ileana

One way around this could be to use a separate table to hold the unique number which is incremented by a set number using a Update Command on a page before, then use a recordset to call that number and insert on your order page.

You do not say how you are incrementing the number at the moment.

Hope this is helpful.