I'm new to InfoPath. I have an existing access form and I'm trying to re-create it in InfoPath. I have 5 tables. See relationships below. I want the user to be able to pick a company from a drop down field and fill the rest of the form. Also be able to edit and add.
Every time I think I'm close I get the error...
"InfoPath cannot open a new form. The form template is not valid." (or a similar message)
and I end up starting over. I think it's because I had all my fields set to a linked data connection instead of the "Main" one. Is that correct?
Ques 1) Should all the fields for all the tables be bound to my "Main" data connection?
Also, I don't know how my 'Main' data connection was initially created (that part I haven't had to redo) but I just renamed Field1, Field2… etc to match my field names and I also just right clicked to add more tables and fields so the structure 'look' matches my linked tables structure.
Ques2) Is there more that that? Should I be doing more than that or are they just non linked fields?
Ideally I'd like the 3 tables linked to tblContactData to be sections that but don't show unless they are clicked on. But once selected it will show existing data and let the user edit or add more and then have the ability to collapse/hide the info again.
tblContactCompany 1 to many tblContactData 1 to many tbContactlJobTypes
" " 1 to many tblContactNotes
" " 1 to many tblPhones