FILEMAKER DATABASE DESIGN

1. Separate the projects according to the Office and Office location. 2. There are three types of project. Dashboard should separate these projects. 3. When sales person from "Office A - Office Location A" login, they are allowed to see their own projects. Same goes to "Office B- Location B" or "Office A- Office Location B" and so on. 4. Joint Projects are special projects shared between "Office A" and "Office B" or "Office A - Office Location A" and "Office A - Office Location B". Users who are the owner of the Joint Projects should view their projects too. 5. Quick Stats is the combination of all three above mentioned projects . Quick Stats on the dashboard should change according to the user's projects. 6. Sales Director of Office A - Office Location A can see all the staffs projects who belongs to Office A and Office Location A. 7. Quick Stats for the Sales Director should also change according to the projects that he can see ie. Overall projects of "Office A" and "Location A". 8. Sales Director are not allowed to see any other projects where their office staffs name is not assigned or entitled. 8. CEO and Operation Director can see all the projects. QUICK STATS should change according to the projects that are in the present in the table.