Hi all,
I am new to database design and am looking for any suggestions or help that may make this an easier task for me. I am creating a database to track how much time is spent working on Eng documents (drawings,specs,calcs). Each drawing may also belong to a change order (ECN,DCN). Many drawings make up a change order and a dwg may be in more than one. Each employee (designer, engineer, checker, etc) is going to need to access a form to input the document worked on, change associated with the doc (if any), and the status of the doc (develop, check, review). The goal is to be able to track the time spent by each employee on each document.
Any help on this would be greatly appreciated.