I have a database with a Job main form and a EmployeeDuties response form. We create a Job form for each job and then create EmployeeDuties as responses for each employee working on the job.
I can happily create a view which lists the jobs and the employees working on them, and their duties. What I now need to do is the reverse. I need a view of all EmployeeDuties forms (first column employee, categorised) with the Job's they have worked on listed for each. So I would have the EmployeeName field categorised, several fields from the Job doc, some of which will be categorised, followed by the DutiesDescription from the EmpDuties form.
1/ Is this possible if I have the given form structure?
2/ In the past when I've needed this funcionality, I've made both forms Docs (not responses), and then built the views. It works but is complex. So, os there a better way to get this result?