Separate tables or single table with queries?
- by Joe
I'm making an employee information database. I need to handle separated employees. Should I a. set up a query with a macro to send separated employees to a separate table, or b. just add a flag to the single table denoting separation?
I understand that it's best practice to take choice b, and the one reason I can think of for this is that any…