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:
ID Int Not Null PK
CatCode varchar (32)
CustomerID INT Not Null PK
What is the best way to do it?