DECS can handle "one-to-many" relationships quite well and the keys to doing this are the "Monitor Order" and "Multi-value data" settings. On the DECS Activity form see Events-Optinos-General for these fields. To get data from multiple tables to appear on a single Notes document you would create one Activity for each table. The Activity that pulls in the "one" data must have a monitoring order of 1*. Your "many" data would be a subsequent job with a monitoring order of 2 (or 3 or 4... hopefully you get the point). For the "many" data you also need to select the "Multi-value data" option (in the same section of the DECS activity doc). When you select the Multi-value option you will see additional fields that let you specify the "many" key field(s) and how you would like to handle sorting the incoming data. I typically use a table with multi-value fields to display the data. *If there is other data that must be pulled in first to get the "one" data key then the monitoring order might be higher than 1.
Dig Deeper on Domino Resources - Part 7
Related Q&A from Scott Lemieux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.