Share
Report
218Hi, to populate word I have a SQL table. It pulls in the data fine. For additional data, not driven by the ID from that SQL Server table I would like to write an output expression (I believe) to yield a result I'm looking for. Based on feedback from someone, I created an array from an Excel worksheet. I have this same data in another SQL table too.
Sample Table
| Control Name | Control Detail |
| ABC123 | This is the detail for ABC123 |
| DEF123 | This is the detail for DEF123 |
My goal in the Word document is to have an entry for the control detail somewhere in the document. For instance, {ABC123 - Control Detail} and have the expression pull the detail for control ABC123. This is one example. I have hundreds of different entries/fields I will be placing in the Word document. It's fine, since those will most likely rarely change.
FYI / I created the array as a recommendation from someone in the forum. Whatever the best way to do it would be great.
Thanks for any insight!
All responses (
Answers (
