My experience of Access is very limited, so in order to obtain a better
understanding my aim is to create a small database that will help me to
manage incoming and outgoing correspondence.

The correspondence comes in with its own reference number, date, sender and
recipient etc.

The database will be used to store the correspondence details and allocate a
Company Document Reference number.

The table headings are shown below.

Project ID
Project Name
Project No
Project Start Date
Project End Date

CompanyDocumentReferenceID
CompanyReference No

IncomingDocumentRefernceID
IncomingReference No

RevisionID
Revision

DateID
Date

Sender/RecipientID
Name
Initials
Position
Discipline
Company

Document TitleID
Title

DocumentTypeID
DocumentType

The primary key is allocated to the word xxxxxID in each table. Is this
correct?

Should ther be any other type of key in the table and if there is how is it
included.

Should the CompanyDocumentRefernceID be in each table?

If the CompanyDocumentRefernceID goes in each table how are the tables
linked for the relation ships.

Many thanks for any assistance provided.

Zephyr