I have a database that is built and is being used by my company I work at. It's an employee database that is used as a directory to know each persons contact number as well as the building/shift they work, etc. The manager wants me to add in another option to the 'employee details' form, which is linked to my 'employee table', to include on another tab the following info for the specified person:
Card Access badge #
Key #
Excess keys (larger text box if they have multiple, whichmost people want)
Facility PIN
Arm/Disarm code
Doors they have access too
Locker #
Lock #
Lock combination
Problem is that some people may have multiple things in a few of these fields and he mentioned he may want reporting to pull specific information. ex. report to specify every person who has access to building A or how many keys does employee B have and to which buildings.
Just really need to know if it sounds like this type of information would need to be broken into multiple tables or if there is a way to gather this information if it were all added into the employees table.