Integration Builder using query prompts
I am trying to build an integration that will print a document when I insert a record into a database table. I have the ODBC set up in the document and also in the integration. I want to print the document using the values from the fields in each new database record detected. I have a query prompt set up in both the document and the integration but it is giving me a "No records found" error. I know the records exist and I can select them when manually printing the document from Designer.
The problem I am having is that the integration will print all records for each record detected. I need it to print one copy of the document per record detected, and I need the values from that record to be printed on the document.
So if I insert 3 records, I need 3 total prints, each one containing data specific to its record. Is there a way to achieve this goal?
Please sign in to leave a comment.
Comments
0 comments