0 Replies Latest reply on Nov 14, 2015 4:14 PM by ZoocMan85

    Need Guidance On Table Setup and Layout

    ZoocMan85

      Hey Everyone,

       

      Im creating a salesboard application that tracks monthly stats and i need some advice and help.  Currently right now i have a employees table that stores name, employee id, birthday , address...etc.  I have another table called Salesboard which is where you would enter the employees stats for the month. However two things im struggling with.

       

       

      Issue 1

      1. I want to have the data listed for all the employees for the month on one screen. This would be displayed on a tv. Id imagine i would do this in report view.

       

      Table 1 Employees.

      Primary Key -Employee ID

      Field 1-Full Name

       

      Table 2 Sales board.

      Foreign Key is Employee ID

      Field 1-Full Name  This should all be pre-populated from Employees Table.

       

      How do i get the sales board layout to pre-populate all employees names that are taken from the employees table ?

       

      Issue 2

       

      What is the easiest way to end the month and start the month and zero out all employee data and make that as a record to go back to as a reference. For ex the data below would be the month of October. Id want to use this as an archive.

       

      Full Name Field          New Cars      Used Cars

      John Smith                       2                    5

      Ray  Charles                    1                    7

       

      I dont know if over complicating this by having multiple tables . Please let me know your input . Thanks and appreciate all your help.

       

      Ray Z