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

Last Post 06 Oct 2010 03:58 PM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
berdia
New Member
New Member

--
06 Oct 2010 04: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.
rm
New Member
New Member

--
06 Oct 2010 03:58 PM
Sounds insert trigger has play here.
You are not authorized to post a reply.

Acceptable Use Policy