insert Client.ClientName, ProjectProjectName,ProjectNumber,Tbpacks.tbpacksName,Tbpacks.tbpacksNumber,Tbpacks.Division
INTO Projects, Clients, BidPackage
Where Project.Client_ID = Client.Client_ID AND
Project.Tbpacks_ID = Tbpacks_ID AND
Client.Client_ID = Tbpacks_ID And
Tbpacks_Project_ID = Project.Project_ID

 
 1)insert Clients values( ClientNameTxtBox )
    --a trigger for this table after insert to get @@identity (which is client_id);store it in local a variable @identity1

2) insert into Tbpacks values ( Name TxtBox , Number TxtBox, Division TxtBox ) 
  --a trigger for this table after insert to get @@identity (which is  tbpacks_ID ) ; store it in local a variable @identity2 

3) insert into Projects( Client_ID, tbpacks_ID, ProjectName, ProjectNumber) 
      values ( @identity1 , @identity2, ProjectNameTxtBox, ProjectNumberTxtBox )

quote:

---

Originally posted by shelbyoh

when a person fill out the form which has the following text boxes

Client Name:
Project Name:
Project Number:
tbpacks Name:
tbpacks Number:
Division:

and click on save they data need to insert into the follow column in the database and also when a person go to query the database for a client or project number it list all the people relate to the project number I can do query with joins. I put test data manually and the query works. I have problem creating the proper relationship so when they enter data via the form. I need for it to insert across the tables or should I make all one table. I still would have problems with relationship because I have other table that has to reference the tables.help please.

 
 1)insert Clients values( ClientNameTxtBox )
    --a trigger for this table after insert to get @@identity (which is client_id);store it in local a variable @identity1

2) insert into Tbpacks values ( Name TxtBox , Number TxtBox, Division TxtBox ) 
  --a trigger for this table after insert to get @@identity (which is  tbpacks_ID ) ; store it in local a variable @identity2 

3) insert into Projects( Client_ID, tbpacks_ID, ProjectName, ProjectNumber) 
      values ( @identity1 , @identity2, ProjectNameTxtBox, ProjectNumberTxtBox )

But I don't know enough about Databases to do so.

---

DECLARE @Client_ID int,@tbpacks_ID int

insert Clients values( @ClientNameTxtBox )
SELECT @Client_ID=SCOPE_IDENTITY()

insert into Tbpacks values ( @NameTxtBox , @NumberTxtBox, @DivisionTxtBox ) 
SELECT @tbpacks_ID=SCOPE_IDENTITY()

insert into Projects( Client_ID, tbpacks_ID, ProjectName, ProjectNumber) 
      values ( @Client_ID , @tbpacks_ID, @ProjectNameTxtBox, @ProjectNumberTxtBox )

...