Correspondence tracking

[fucell26]

hello to all. im new in this forum and also in access 2010.

can someone help me give me an idea how to construct my database.

they've given me a task to make a tracking and recording those incoming and out going correspondence.

i have an idea ms access but the database for this task gives me a hard time.

in my data i have the following which is encoded in excel:

*Letters that we received. Incoming and outgoing.
-Letter date
-Reference number


-subject
-from
-to

*Inside Contacts (companies employee)

*outside contacts (sender from different company)

need help to have a better construction/design of the database for this.

really appreciate for kind help guys.

thanks,

fucell26

[orange]

see the existing models here

[ranman256]

What about [IO] field? (incoming, or outgo)