Main data connection in InfoPath

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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Clay FoxDirector of Business IntegrationCommented:
You would want to create a new database type form based on the Contact Company table.

When you get to the wizard page that displays the field in the table click on add table.
Select the Contact Data Table. Setup the field relationships. Then add the next table adn so on until you have all of the tabels and fields there.

Then complete the wizard.

Then if your tables have the correct Kays etc you should be able to query and submit these tables.  And they will all be apart of your main data connection.
BobRosasAuthor Commented:
Thank you for your response.  I really do appreciate it.  I'm just still trying to figure out the first line of your comment.  Does that mean I need to create a new Data Connection? Because I went ahead and did that.  I went thru the Data Connection wizard and added my tables and links and called it Main. I already had 3 data connections (see attached picture).  Now it looks like all it did was add a 2nd "Main" connection instead of overwriting the first one.  So now Main (Secondary) and EmployerContactsGetInfoPath(Secondary) are essentially the same thing.  The "EmployeContacts..." connection was what I was using and kept getting the error mentiioned in my original post.
Clay FoxDirector of Business IntegrationCommented:
No unfortunately you have to start over with a completely new form.

Database type forms are special and setup on the original creation to be built around your tables.

That will make a new main data source that is the way you want it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BobRosasAuthor Commented:
Not the answer I was hoping for but I do appreciate your help.  I'll start over and post related questions if needed.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.