Need help creating a MS access Employee Equipment Tracking
Posted on 2010-08-16
I am starting to build an Access database that help me to keep track of Employees' equipment such as PC, Monitors, Printers,Blackberries, and software (Visio,Adobe;etc) and also I would like to keep track the date that each equipment has been installed. My idea is to have a table for each equipement and then the primary key of the employee table will be in each of the equipment tables. That way i create a one to many relatioship between employee and Pc and so on. The problem is that not every employee has a blackberry or a loptop, and most of employees have two monitors , so i am not sure if my idea will work well enough. Please can you assist me with this.