My application consist of region,compaign(IBM,Microsoft,Dell),Line Of business(lob),weekly schedules of employees,Employee Data.User(Company Authority
uploads weekly schedules of the employee by selecting region,Compaign and LOB in dropdownlist.
Should i need to use master table for this,if yes can i use same master for the all the compaigns.
One authority may upload dell copmaign data with 500 employees schedule,another authority may upload microsft compaign schedule.
Give me table struture for this.
EmpNo,EmpName,Monday(date and tiimings in and out).sunday,Region,Compaign and LoB