Re: Cannot Connect and submit 2 tables by one field relationship

Hilary Stoupa — Fri, 13 Mar 2009 15:25:28 GMT

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.

Cannot Connect and submit 2 tables by one field relationship

Ian Dawson — Fri, 13 Mar 2009 06:01:01 GMT

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

Data Connections

Re: Cannot Connect and submit 2 tables by one field relationship

Cannot Connect and submit 2 tables by one field relationship