Solved
How should I structure my tables?
Hi All,
I'm going to start my very FIRST! app. It will be an Employee tracking app, but my problem I am trying to figure out is, I have hundreds of employees in 6 different geo locations and several job types on different shifts.
Should I create a tables for Employees in each location? (i.e. LA, Boston, Etc.) or 1 Employee table with Name, Job, Location, Etc.?
Thanks in advance for your guidance!
------------------------------
William Wallace
------------------------------
I'm going to start my very FIRST! app. It will be an Employee tracking app, but my problem I am trying to figure out is, I have hundreds of employees in 6 different geo locations and several job types on different shifts.
Should I create a tables for Employees in each location? (i.e. LA, Boston, Etc.) or 1 Employee table with Name, Job, Location, Etc.?
Thanks in advance for your guidance!
------------------------------
William Wallace
------------------------------
- One table of employees! .. with a multiple choice field to indicate the location.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
