Detail page on insert

Asp ecommerce site

[Jimmy_Blue]

Hi all at WW

I'm in the process of designing a backend for our ecommerce site and have stumbled across an issue which I would sincerely appreciate some guidance on.

The scenario:

I am inserting new customers for catalogue and telephone sales directly into the backend. The customer table is constructed with an autonumber field called Customer ID.

I am trying to find a way that I can redirect immediately to a detail/new order page of the customer that I have just inserted on submit.

Any ideas?

Many thanks

[korkus2000]

Are you asking about response.redirect or something else?

[Jimmy_Blue]

Not exactly. (at least I don't think so)

I need to somehow get the newly generated unique ID to populate the next screen.

For example, say that a new order is telephoned through. I would access the new customer screen and input the new details in the insert form. Once I have finished that I want to next view the detail page (which also includes the new order link) of the customer that I have just input. At the moment I am having to re-search for the customer in the database and follow the links through to place the order. In other words, is there anyway of passing the newly generated Customer ID onto the next page.

[macrost]

Jimmy_Blue,
I suppose that depending on the type of db that you use, you could, after the new record has been added, on the next page you can call that new record. What db are you using?

Mac

[Jimmy_Blue]

Hi Macrost

I am using an Access 2000 database. The main problem is that I don't know the unique ID of the new customer as it is an autonumber field. I therefore have to search on the name immediately after.

[macrost]

You know, you might be able to do this... generate a unique id number that get's inserted into the new customer's field. Then immediately after you will be able to pull that record by the unique id. Session.SessionID is the unique session id number for each user. Or you can manually generate your own number.

Mac