We have a database of employees and many related tables (like EmployeesNotes, EmployeesSchedules etc..).
Now I'm looking to create a copy of that database with only part of the employees (that meet certain criteria).
For those employees I would need all related database tables.
What is the easiest way to accomplish that?
FYI- We have an Access FE application that I would like to setup as test linked to the copy of the database, so users can test if all data are included.
Would prefer something that would also be easy to fix/implement in case users find something missing, not to have to redo everything.
What would you suggest?
Thanks in advance!