InfoPath Dev

I am unable to connect 2 tables, one is the customer table the other is the supplier table.

When I Make the data connection. the wizard comes back with the submit function DISABLED.
And saying there is a many to 1 relationship. Which will occur.

I will (should) only ever have one supplier for a customer. 

So ANYONE OUT THERE, how do I design the FORM to allow submit between these two tables.

I AM NOT using SharePoint, nor am I using SQL.

I have tried having JUST the 2 tables in the main database connection.
NO Good,  UNLESS there is a special control, or table relationship I have yet to use.

I have tried having just one on the Main data connection and the other one loaded as a secondary database connection.
Each time I try to add I get a warning " Only the first record will be returned"

Surely there must be a way to connect them???

ANY HELP out there anyone?

It is all on the computer, NO Networking, and using MS Access 2007

Are you connecting to the supplier table first and then adding the customer table? You say you are getting a message about a 'many to one' relationship, but since you state there will only be one supplier per customer, you would need to make that your primary table.