Member Avatar for GLT

I wish to transfer data from a potential customer table to a customer table in my database if and when they become a customer and not just an enquiring customer. I need to be able to do this simply but I have no idea how. I am using ASP and SQL Server 2005.

anyone any ideas??

Thanks Guys!
GLT

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by webthang_rob
Member Avatar for webthang_rob

Would it not be more convenient to simply have a field in your user table that declares what type of user the user is?

ie.
Fieldname = UserType
Value = Prospect / Customer

But you could just as easily fire an insert command against the 1st table into the customer table pulling the details required based on the ID of the user. You'd have to remember to either flag the original user record as moved or remove it completely.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.