Inserting new records into the DB with related tables

[MedicRanger]

Hey all,

 

I have a problem with inserting new records into a database when it is a child table.

 

I have a connection to an Access database and have a respective data adapter and command builder for each table in the database. When I fill the dataset, I then build the appropiate data relations programmatically and use it how ever I need to.

 

I can delete and modify records from the child tables just fine, but when I try to insert a new record into a child table, I get a "SYNTAX ERROR IN INSERT-INTO STATEMENT" dialog when I try update the database and the process fails.

 

I am guessing it might be a conflict in the command builder, but I don't know how to fix it. Can anyone help me?

 

All datafields are Text except for TripNumber and ID, which are integers.

mod_tripdatabase_returntripbyindex.vb