As correctly said by Amir, you have to use stored procedure and here goes the sample implementation
1. Create t1
CREATE TABLE [dbo].[t1](
[tid] [int] IDENTITY(1,1) NOT NULL,
[taddress] [varchar](max) NULL,
[tdate] [date] NULL,
CONSTRAINT [PK_t1] PRIMARY KEY CLUSTERED
(
[tid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
2.Create t2
CREATE TABLE [dbo].[t2](
[tiid] [int] IDENTITY(1,1) NOT NULL,
[tcontactno] [varchar](50) NULL,
CONSTRAINT [PK_t2] PRIMARY KEY CLUSTERED
(
[tiid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
3.Create t3
CREATE TABLE [dbo].[t3](
[toneid] [int] NULL,
[twoeid] [int] NULL
) ON [PRIMARY]
4.Create stored procedure
Create PROCEDURE spInsertContact
@address varchar(max),@contactno varchar(max),@tdate date
AS
BEGIN
SET NOCOUNT ON;
Declare @toneId int,@twoeid int
insert into t1(taddress,tdate) values (@address,@tdate)
set @toneId=SCOPE_IDENTITY()
insert into t2(tcontactno) values (@contactno);
set @twoeid=SCOPE_IDENTITY()
insert into t3(toneId,twoeid) values (@toneId,@twoeid)
END
5. You can sample execute the stored procedure
spInsertContact 'sample address1','sample contact 1','13 jun 1990'
hope this helps, i have tested in SQL 2008 and it works