Vendor Time Cost Tracking Database

[mjohnson02]

Hi All,

I am creating a database for tracking vendor time during big projects here. I would like to create a database where i can have multiple sheets with information linking to one form where i enter timesheets. I want the timesheets that i enter to populate in a report organized by major component then the work order. The vendors have multliple rates for the trades that they provide and it causes me to have the vendor showing up multiple times. I would like when i select the company, the trades available for them populates, then the shift and that it will populate the rates available. (i know it sounds complicated but i know it can be done i am thinking positive).

My problem is getting all that together so that i can have a cost tracking database for vendors. I have uploaded my database. Please help as this is part of my goals for the year. I need to create this before november.

I have access 2007..

Thank you.

[orange]

I recommend this tutorials/videos as a starting point.

Principles of Relational Database (short and very good)
http://forums.aspfree.com/attachment...2&d=1201055452

Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

Video tutorials:
These are quite good for learning by Watching/Listening
rather than reading.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

Good luck.