those two foriegn key column can map,If i know how to map others .

I select ka fk column values by selcting them with some criteria and map theses key with variable and pas them to insert queries.

DECLARE

@visid int,

@msginID int,

@@gsmno nvarchar(5)

Select @msginID=fk_msgIn_Id,@visid=fk_visbox_Id from messageIn_Tb where GSMno =@gsmno

I want to map the values as i did in above code.Is it possible and how ?