AnsweredAssumed Answered

Proper tables for the solution

Question asked by tmilas on Apr 25, 2015
Latest reply on Apr 26, 2015 by dsvail

I’m trying to set up a solution to track daily production.  We have six products (that are built in six different workstations - one workstation for each product). There are 12 people working in this department.  I want to track hours per each product, (people log their time spent on particular product and they can work in different workstations).  Some workstation can have more than one person working simultaneously.  So I need to track quantity of each product per day, who made it and time spent on it (with ability to make reports and graphs (weekly and monthly).  I want to see a list of products made by a person(s) and daily production.  My problem is the proper setup of tables (ERD)… any ideas? I tried to setup a “Date” as a primary table—that didn't work too well.  Any help would be greatly appreciated.