Connect Access to InfoPath

[Wolverine]

We would like to create an User Satisfaction Survey using InfoPath & Access
as the backend. To test it, I set up 2 Tables in Access. Survey & User and
defined a relationship between the tables.

I opened InfoPath & connected to the DB, adding the 2 Tables as required.
However, after going through the Wizard, the final screen says that the
"Submit Status is Disabled as a Many to One Relationship might exist between
two tables in the data source." Well, naturally, this is correct, there is a
relationship. A Survey can be completed by Many Users. I'm totally
confused. How can I get users to complete & submit InfoPath Forms, storing
the data in Database?

Thanks in advance.

 

[Carl Frisk]

It is talking about a many-one database table and index relationship. Nothing to do with the number of users.

 

[Wolverine]

Thanks for your response, however, I'm still not sure how I get InfoPath to
accept a Database with Relationships. Or are you saying that it can't deal
with Relationships?

Thanks again.