Submit status: Disabled - Many to One relationship may exist in DB

[Misty]

I am trying to set up a form based on an existing relational database in
Access. I have about 16 tables and all of them relate in some way. Some of
them are related to multiple tables as a one to many relationship. Why does
InfoPath not allow you to submit when this is the case? I am new to InfoPath
and I was hoping to use it as an alternitive to using Access as the total
application. I wanted to use both InfoPath and Access as the total
application. I have read that you can try to use some sort of Web Service to
accomplish this, however at this time I do not have the ability to
incorporate a web service. Is there any way around this? Can someone please
offer some suggestions? I have been searching the How To articles and the
different discussion groups for hours (literally days) and haven't found
anything that can explain or help me understand why InfoPath doesn't allow
you to submit form information to a database that has one to many
relationships, or any postings on how to get around this.

I am begging for any help possible.

Thank you in advance.

 

[Land]

Hi,

Infopath support create sheet based on database and update it directly, I
have tested that function in SQL database system.
I suggest you check:
(1) Whether you defined the relationship when you create data source, you
can click "Add table" button after you selected the main table.
(2)Is ther any BLOB data types in your database? Infopath really does not
support update BLOB data types directly.

wish helpful.

 

[Misty]

I did define the relationship when I created the datasource, and I did make
sure that all the datatypes in my db fields were supported by InfoPath. I
don't know what else to do. I have tried adding the different tables in
different orders and a few other things. There is absolutely no way that I
can think of to change the database so that all the tables are only connected
to one other table. I have thought about using sort of a junction box table
to connect all the tables to, but wouldn't that create a many to many
relationship? I just don't think that I would be able to do that and have
the database function properly.

I don't know what else to do. Is it pointless to use InfoPath if it doesn't
support multiple relationships? Is there no way around this submitt problem
I am having?!?

I really apreciate any help or suggestions anyone has.

Thank you in advance!

 

[Mike]

Misty, did you make sure that you entered your tables into infopath so that
they have the same relationship as they have in access. sounds like you may
have entered a table into infopath as a child, when it is a parent table in
access. try viewing your access table relationships, then make sure that you
enter the tables into your data connection so as to keep the relationships
the same. hope this helps. ~Mike