SQL Server : can insert into child table [closed]
-- Referrals
CREATE TABLE RSSreferral
(
    ReferralID INT PRIMARY KEY IDENTITY(1,1) NOT NULL,
    RefType VARCHAR(25) NOT NULL,
    RefName VARCHAR(25) NOT NULL,
    RefPhysical_Add VARCHAR(25) NOT NULL,
    RefPostal_Add VARCHAR(25),
    RefEmail VARCHAR(25) NOT NULL,
    RefTele VARCHAR(25)NOT NULL,
    RefFax VARCHAR(25));

--Client Referal Associate
CREATE TABLE RSSclient_referral
(
        ReferralID INT FOREIGN KEY REFERENCES RSSreferral(ReferralID) NOT NULL,

    RefDate DATE NOT NULL,
    RefReason VARCHAR(45) NOT NULL,
    CONSTRAINT [PK_ClientReferral] PRIMARY KEY CLUSTERED (ReferralID)
);

CREATE PROCEDURE Add_ClientsReferred
(
        @ReferralID INT ,

    @RefDate DATE,
    @RefReason VARCHAR(45)
)
AS
INSERT INTO RSSclient_referral (ReferralID,ClientID,StaffID,RefDate,RefReason)
VALUES (@ReferralID,@ClientID,@StaffID,@RefDate,@RefReason)
GO