Problem inserting ID value from one SQL table to another using CreateUserWizard

Last Post 06 Oct 2010 02:58 PM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

06 Oct 2010 03:35 AM
I am need to insert ID value (CustomerID) from one table (Customers) to another (Categories) when new user is created.
Following is my tables structure:

Categories Table:

ID Int Not Null PK
CustomerID Int
CatCode varchar (32)

Customers Table:
CustomerID INT Not Null PK
Title Char(32)
FirstName Char(32)
LastName char(32)
CompanyName char(32)
Email char(64)

What is the best way to do it?

Thank you.
New Member
New Member

06 Oct 2010 02:58 PM
Sounds insert trigger has play here.

Acceptable Use Policy