Create Table

Give tablename Fields OK Cancel Help

 

Create a table in your database to store information about your created documents and easily reopen them using the hyperlink. You will use this when turning your database into a document management system.

Note that you can change the proposed fieldnames, and also can make any changes to the tbale at a later stage.

Started from tab Log on the Mail Merge Wizard.


Give tablename

The name of the table to be created in your database

Fields

ID_doc Hyperlink DateCreated Template Author Process Title Subject Status Category Keywords Comments id_related tbl_related

ID_doc

An ID generally a useful field to have in any table

DateCreated

By default this field will be automatically filled

Hyperlink

The hyperlink field will let you open the document directly from the table, without having to go to explorer. The description [Hyperlink ] is set to to allow automatic preselection when Log is added to a process.

Template

With many documents being created in the database this obviously is a useful field for sorting and filtering. The description [Template] is set to to allow automatic preselection when Log is added to a process.

Process

May be redunant when you selected template. However it allows extra filtering if your mail merge process creates multiple documents. The description [Process] is set to to allow automatic preselection when Log is added to a process.

id_related

Having a field id_related (or another more suitable name) allows you to combine the document record with records from other tables, such as an order or customer) using queries.

tbl_related

If you want to relate an id to multiple tables such as tblContracts, tblInvoices, etc. You can then make a query which looks like

SELECT * FROM tbl

Title, Subject, AuthorCategory, Status, Keywords and Comments or other commonly used fields.