Insert values to SQL Server & PHP connection with foreign key [duplicate]

We are developing a columbarium management system

We are trying to get data entry from deceased and customer entries (single form) to their tables and for some reason we cannot get the data to store in database

Here is the stored procedure

CREATE PROCEDURE insertDC(
  @DLastName VARCHAR(50)
, @DFirstName VARCHAR (50)
, @DSex VARCHAR (6)
, @DateOfBirth DATE
, @DeathDate DATE
, @DeceasedNo INT
, @CLastName varchar(50)
, @CFirstName varchar(50)
, @CSex varchar(6)
, @ContactNo numeric(11)
, @CustAddress varchar(50)
)
AS
BEGIN

INSERT INTO Deceased(DLastName, DFirstName, DSex, DateOfBirth, DeathDate)
VALUES(@DLastName,@DFirstName ,@DSex ,@DateOfBirth ,@DeathDate)

INSERT INTO Customer(DeceasedNo, CLastName, CFirstName, CSex,ContactNo,CustAddress)
VALUES(SCOPE_IDENTITY(), @CLastName, @CFirstName, @CSex,@ContactNo,@CustAddress)
END

And this is the database connection in PHP

if($_POST['CSubmit'] == "ADD")
{   
    $serverName = ""; //serverName\instanceName
    $connectionInfo = array("Database"=>"");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);
    if( $conn ) 
    {
        //setup variable data
        $DLastName = $_POST['DLastName'];
        $DFirstName = $_POST['DFirstName'];
        $DSex = $_POST['DSex'];
        $DateOfBirth = $_POST['DateOfBirth'];
        $DeathDate = $_POST['DeathDate'];
        $CLastName = $_POST['CLastName'];
        $CFirstName = $_POST['CFirstName'];
        $CSex = $_POST['CSex'];
        $ContactNo = $_POST['ContactNo'];
        $CustAddress = $_POST['CustAddress'];       

        $sql = "EXEC insertDC @DLastName = '$DLastName', @DFirstName = '$DFirstName', 
        @DSex = '$DSex', @DateOfBirth = '$DateOfBirth',@DeathDate='$DeathDate',
        @CLastName = '$CLastName', @CFirstName = '$CFirstName', 
        @CSex = '$CSex', @ContactNo = '$ContactNo',@CustAddress='$CustAddress'";        

        $stmt = sqlsrv_query($conn, $sql);
    }
}

We are also having trouble on how do we link the foreign key to other tables.

Please help.