I want to make stored procedure for the TABLE1 that have another table column that are not primary key in sql server

I have two table

Maker(maker_id(PK), maker_code, maker_desp)

Model(model_id(PK), model_code, model_desp, maker_id(FK))

Now I have a gridview 2 in asp.net c#

MAKER TABLE (GRIDVIEW 1):

Maker_id, Maker_code, Maker_desp

MODEL TABLE (GRIDVIEW 2):

model_id, model_code, Model_desp, maker_code

Now I want to make crud stored procedure for the MODEL TABLE that have another table MAKER TABLE column that are not primary key in sql server

PLZ... PLZ… help I spent my 3 days for finding and making solution

Meanwhile this is what which I have done

use logistics

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[maker]

(

mkid int identity(1,1) not null,

mkcd char(5) null,

desp char(15) null

CONSTRAINT [PK_maker] PRIMARY KEY CLUSTERED

( [mkid] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON

[PRIMARY]

) ON [PRIMARY]

GO

CREATE TABLE model(

[mdid] int identity(1,1) not null,

[mkid] int null,

[mdcd] char(5) null,

[desp] char(15) null,

CONSTRAINT [PK_model] PRIMARY KEY CLUSTERED

(

[mdid] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,

ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

/*******FK******/ use logistics

ALTER TABLE [dbo].[model]

WITH CHECK ADD CONSTRAINT [FK_Model_Maker]

FOREIGN KEY([mkid])

REFERENCES [dbo].[Maker] ([mkid])

GO

ALTER TABLE [dbo].[model]

CHECK CONSTRAINT [FK_Model_Maker]

GO

insert into maker(mkcd,desp)values('asd','qwerty')

select * from maker

select * from model

CREATE PROCEDURE [dbo].[model_pro]

@mdid int,  

@mkid int,  

@mkcd char(5),

@mdcd char(5),  

@desp char(15)

AS

    BEGIN

        SET NOCOUNT ON;

        SELECT

            md.mdid,

            mk.mkid,

            --mk.mkcd,

            md.mdcd,

            md.desp

        FROM model md

        left join 

        maker mk on md.mkid=mk.mkid

        insert into model(mdcd,desp)--mkcd

        values(@mdcd,@desp)--@mkcd  

  END

look now I want to mkcd and @mkcd column add in procedure for enter record in gridview or make like resultset