I have 3 related fields, and I'm trying to figure out a good way to build a table that displays all three. I have Employees, CertificateTypes and Certificates, with Certificates linking Employee and CertificateType. CertificateTypes are basically types of training an Employee can receive and Certificates are the training an Employee has received in a CertificateType.
Eg: (a parallel example): a student can receive a diploma for a Bachelor of Science, w/ Employee=student, CertificarteType=Bachelor of Science and Certificate=diploma.
I want my table to show all Employees as rows, CertificateTypes as columns and the Certificate expiry date as the cell value.
I could build a list/dict in my view, or I could try and build it in the template (I was looking at the regroup template tag). What's the best/easiest way to do this?