I setup my tables and relationships like stated above but get the following error when I create the Data Connection:
A many to one relationship might exist between two tables in the form
What am I doing wrong?
This would be refering to the relationships between the tables.
Are you using Primary Keys for each table?
What is your layout?
LaborSummary
Autonumber(Primary Key)
CA
xxx
LaborSummaryCommentsLabor
CA_L
Comments
I have a CA to CA_L relationship setup between the two tables...which will be a one to many.
Hi Steve,
Check out the following link: http://blogs.msdn.com/infopath/archive/2006/08/29/730062.aspx. In general, our Database Accelerator Web Service will simplify your form significantly since it will abstract the XML to SQL DB mapping and allow you to define the mapping separately without having to worry about redesigning your form every time the DB changes. Let me know if you want to talk again or if I can show you another demo.