Hi there,
I have created a fully functioning database that collects incident information.
Really my question is regarding best practice and design.
within my access database I have used multi value fields to assign managers to multiple services. I am transferring to a hosted platform and it struggles with my design.
So, I have 140 services. A manager has multiple services and each service has multiple managers, 60 managers in total.
Ideally I would use a web form to add new manager and assign what services they had access to.
I have this working perfectly when I assign multiple managers to a service, I just cant get my head around assigning multiple services to a manager without using multivalued fields.
I understand the concept of many to many and they requirement for a third table.
However I have spent the last 12 hours looking at this and think my brain has given up!!
I just cant visualise this or make it work
Any advice on how best to structure this would be great, wonderful in fact.
Help!!
Hazelle