Need Guidance On Table Setup and Layout

Discussion created by ZoocMan85 on Nov 14, 2015

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