Hello everybody,

I need help on setting the table structure of a DB.


I have:


Table DocsTbl with fields.
DocID
DocType
DocSubject
DocDate
Ref.Proc
DateProc
DocPath
DocDispach
DocRead


Tables DispatchTbl
DispID
dDocID
DispText
DispDate
DispTo


DesinationTbl
UserID
DispID


AccTionTbl
ActID
ActUser
ActDate
ProcessNum
AcText


When a document is registered in DocsTbl, the boss insert a dispatch
stored on Dispatch table, and he could insert more than one dispatch
over the same document, the user needs to take some action in
accordance with that dispatch. How should I establish the relations,
taking in attention that one dispatch could concern just to one user
or to several users, in this case each user should take an action
and
store the action and register each action.
In the end, the goal is to have trackin on received Docs, each
Dispatch that were inserted in a particular Doc, and each action
taken
by user on each dispatch.
As an output shoud have list of entered Docs, Dispatches inserted and
actions over those dispatches, each user could chose to see his own
actions or all.


The scheme is:


Entering Doc ---- 1st Dispatch ---- User1 Action
---- User2
Action
----- 2nd Dispatch ---- User1 Action
---- User2
Action


hope I was clear enough.
thanks all