Implementing database structure

J

Johnny

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top