I went through the Getting started manual for DBXL and was able to get the expense report to post data to my dummy tables. Now, I have moved on to one of my actual forms and am having difficulty getting the data to post into my SQL tables. With the data post I will be posting to multiple tables. I am able to get the data to post to the main table by itself. However, when I start to add the child tables the data will not post anymore. I'm not sure what I'm doing wrong. I've made sure that all the mappings were complete in my configuration. I've attached a snapshot of my configuration. The two SQL tables that I'm testing are below.
Main table:
ID bigint 8 0
EmployeeNo char 10 1
EmployeeName varchar 50 0
Email varchar 70 1
Work_Summary varchar 1000 1
Accreditation_Affliation varchar 50 1
PE_Certification bit 1 1
LEED_Certification bit 1 1
Child table:
EmployeeID bigint 8 0 (Foreign key to main table)
EducationID bigint 8 0 (Identity set to Yes)
School_Facility varchar 50 1
Degree_Completed varchar 4 1
Completion_Date datetime 8 1