I am getting a message when I try setting up my DB connection that the submit
status is disabled due to there being a one to many relationship. As far as I
can tell there is no such relationship. This is Between three forms that all
have one field in common, but do not share any like data within that field.
Adam Harding - 18 Jul 2005 11:02 GMT
In your DB Connection do ANY of your tables have a 1-2-Many relationship. Go
into Access or SQL look at "relationships" and see what is linked. It will
only say this if the DBase has a link that isn't refleted in Infopath. Also
make sure that EVERY field you want to publish data to has a "Key Field" ie
ID as it cannot write to it otherwise.
> I am getting a message when I try setting up my DB connection that the submit
> status is disabled due to there being a one to many relationship. As far as I
> can tell there is no such relationship. This is Between three forms that all
> have one field in common, but do not share any like data within that field.