You can add to multiple tables through Procedure in sql...
procedure
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[P_ItemMaster]
@ItemId int=0,
@ItemName varchar(100)=null,
@SubCategory_Id int=0,
@DenominationId int=0,
@Created_By varchar(50)=null,
@Created_On varchar(100)=null,
@Modified_By varchar(50)=null,
@Modified_On varchar(100)=null,
@COND VARCHAR(1)=null,
@ItemCode VARCHAR(100)=NULL
AS
BEGIN
SET NOCOUNT ON;
IF(@COND='I' OR @COND='i')
begin
insert into T_Itemmaster(ItemName,ItemCode,SubCategory_Id,DenominationId,Created_By,Created_On) values(@ItemName,@ItemCode,@SubCategory_Id,@DenominationId,@Created_By,@Created_On)
insert into T_item_masterDeatils(.......) values(......)
end
END