I'm having a hard time explaining it so I'll just give an example of what I want.
Employees A, B, and C each have two tables. Each has both an Invoice table and an Order table with the exact same fields. I want to keep each table separate so that each employee can only change their own table and I can put different drop downs, etc. in each employee's table. The difficult part is that the boss needs to be able to look at one table with all of the Invoices and run reports on it. Can I do this? Or are there any other good options that come close to this idea? Thanks.