- Edited
I know I've modified the code a bit to allow for this, however it would be nice if departments could be a bit more generic and could substitute for anything (in my case products).
Currently dept_id is a 1 to 1 relationship between user and department (and group for that matter). I've changed from using departments to products, and I have several individuals whom support each product, so user A could support products 1 2 and 3, while user B supports products 3, 4 and 5.
Effectively I've created a pivot table allowing for many to many relationship.
Thank you!!