Using a SQL VIEW with Infopath

[AlexW]

I have an infopath form that pulls fields from 6 tables and then submits data
back to some of the tables. Following a suggestion on this forum, I had a
VIEW created to speed up the process, which works great. However, now I
cannot SUBMIT the form: the setup has this message - "Submit Status not
allowed - a SQL Join
statement was used." I'm told by one SQL consultant that Infopath might
require a specific syntax. Can anyone advise me on the correct syntax for
creating the View? Can Infopath SUBMIT back to the tables via a view?

 

[Art]

A view is generally one way - pulling data from multiple tables

You would need to send the data back to the 6 original tables. But that can
be slow

Unless you create a third table would then replicate back to the original six.

No best solution here.

Does the update back need to be real time or can you store the data and run
updates at night?

 

[AlexW]

Thanks for the tip Art. A temporary table with an overnight update would work
for this. Alex.