Attachment parent table mappings

images\attachmentparentkey.jpg

 

Parent Key mapping:

Primary keys of the parent table must be mapped to attachment column(s).

GeniusConnect uses this mapping to synchronize attachments of a specific item.

Example:

Parent Table “Calendar” has primary key Cal_ID

Attachmet Table “CalendarAttachment” has composite Primary key, Parent_Cal_ID (reference to parent record) and Attach_Nr.

 

Mapping: ParentKey:Cal_id Child key: Parent_Cal_ID

 

The Attach_nr column must be mapped to “Attachment Number” column in Item Attachments dialog.

 

SQL Statements for Mandatory Keys:

images\secondgrid.jpg

You have to specify other mandatory keys for attachments (second Grid),

only if:

-Column is Mandatory in Attachment table
-Column is not linked to an Outlook Attachment column
-Column has no default value for inserts (specified in database)

 

(Working of the second grid is explained in Primary and Mandatory keys help topic.

 

See also:
Item attachments