I'm extending Joomla 3.x with a custom component.
At this point, my model has
- workers: Peter (id: 1), Paul (id: 2), Mary (id: 3)
- roles: manager(id: 1), teacher (id: 2), advisor (id: 3)
- links: link roles to a worker
Now, a worker - say Mary - can have one or multiple roles. With every role comes an individual date when Mary received that role: Mary is teacher since 03/01/2016 and advisor since 02/15/2015.
links.id: 1, worker.id: 3, role.id: 2, date: 2016-03-01
links.id: 2, worker.id: 3, role.id: 3, date: 2015-02-15
In the Joomla backend, I have a worker and a role view. In the worker-view, I'd like to go to Mary's profile and add/delete roles.
I've never seen this.
What field type would I use for that? How is it done?