In InfoPath, I am trying to work out why I cannot Submit to a database.
Well thanks to Hilary's suggestions, I have added keys to all of the tables. Unfortunately, one table which has a primary key to relate to most of the client tables. I cannot see how to set up another key ( a secondary key) to a single supplier table. Try as I might, Access thinks a one to many relationship exists.
And when I redo the data connection, The final Summary advises it feels there is a one to many rel. And disables the database submit.
So I am thinking DO I HAVE TO WRITE SPECIAL CODE in InfoPath to allow a submit?
Any clues? How to etc etc.
Thanks