Creating an Attachments Field

To create an attachments field:

1    Open the project definitions database.

2    Open the tblDtsFields table.

3    Copy the record for the Attachments field and paste it into a new record.

4    Change the nID, tTableName, tName, tCaption, tLabelCaption, and tBoundControlName fields.

5    If you want to put the new attachments field on a different tab, change the nDestinationTabID field.

 

 tblDtsFIelds field

Description

 

nID

Unique ID for the field.

 

tTableName

Name of the attachments table in the issue database. The attachments table stores information about attached files.

Also, the name of a table in the users database (the table is named <tTableName>Temporary).

 

tName

Name of the field in the attachments table of the issue database. Stores the name of an attached file.

 

tCaption

Label used in choice lists.

 

tLabelCaption

Default label for the field in a Web view.

 

tBound ControlName

Internal name for the field.

 

To create an attachments table:

1    In the issue database, copy tblAttachments. Use the tTableName of the new attachments field as the name.

2    Change the name of the tAttachments field in the new table. Use the tName of the new attachments field as the new name.

To create a temporary attachments table:

In the users database, copy the tblAttachmentsTemporary table. Name the new table <tTableName>Temporary.

To add a record to tblDtsTables:

In tblDtsTables (project definitions database) copy the record for the attachments table. Change tTableName and tTableNameTemp to the names of the new attachments tables in the issue and users databases.

Related Topics

About the Databases

Editing Databases