MayFlower develops specialty software products for Lotus Notes & Domino.

---

Chapter 7 - Using a Multi-Part Key Field

Table of Contents

---

When you might use the multi-part key:
Oftentimes, the unique key to a database consists of two or more parts. The Sentinel can handle any number of key values.


Example: Purchase Order Line Items
In this example, we have a purchase order system with multiple line items. The key to the line items is PurchaseOrderNumber and LineItemNumber. To accomplish this, type both of these fields into the Key Fields section of the Task form:
Key Fields
PurchaseOrderNumber
LineItemNumber

This tells Sentinel what information from the source to match to the Destination Notes Database. You must have a View in the destination database with these same fields in the same order, sorted (but not categorized). What the Sentinel will do is try to match these items, PurchaseOrderNumber and LineItemNumber, with documents in the View.


Note: You can use as many fields as you want in the Key Fields section of the Task form.


Tip: You can use one View to support different levels of imports. In this example, you could first import purchase orders using PurchaseOrderNumber and then import line items as response documents using PurchaseOrderNumber and LineItemNumber.

---