Help with table design/normalization

[williams9969]

Greetings-

I am having trouble with the table design of my db.


What I am is a human resource supervisor trying to develope a database to
track the hundreds of actions that come in and out if my office on a weekly basis.

I am almost there, in regards to table setup and relationship setup, except I am stuck on something and any advive I can get would help tremendously.

Here is what is going on:

I need to be able to relate my customers to the actions they turn in..and track them, the actions, until complete.

I have attached my db and will answer any questions needed. Will someone please take a look at it and evaluate what you may think is needed to get the "ball" rolling.

Thank you for your help

DW

 

[ScottGem]

need more info here which table is your customers. What does tblMain represent. What do the feidls in tblAction represent? Anything else you can explain about work flow