Data Access Layer Question

I am using MS SQL Server 2008 r2 and MS Server IIS. I am using DAL in my project.  When a user adds a record to Table 1 a few of those fields are transferred to Table 2 where it adds a new record and places the data from the fields in Table 1 into Table 2’s new record.  That works great!
The DAL code I use to add the record in Table 2 is:
dim dal_table
set dal_table=dal.Table("Table 2")
dal_table.CaseNumber=values("CaseNumber")
dal_table.Date=values("Date")
dal_table.Suspect=values("Suspect")
dal_table.Victim=values("Victim")
dal_table.Add()
This is an example of the results in the Table, Fields, and Record:
 
Table 1
Record 1
...