Forum Discussion
Is there a similar way of structured references with additional rows & columns from single table?
I am trying to make a small employee tracker/database for a federal job. - I would like to have a single master table that has 3 columns and 50 rows of employee info: Column A: SECTION Column B...
villa570 My first though would be NOT to delete employees that have left. Add one more column to the master for their Status (active/inactive). Then I would also add an ID column to all your tables with unique ID's for each employee, to avoid the risk of mixing up employees that might have the same name.
You can use Power Query and/or Power Pivot to merge or relate these tables and create reports for only the active employees.
Edit: But as mtarler suggested, perhaps better to just have one big master table.