I have 3 tables
- Job - Table that has open job requisitions
- Applicant - Table that has records for applicants, linked to job (many to many, as an applicant can apply to many jobs)
- Applicant_evaluation - Table that has records for each evaluation made for an applicant, as interviewers people can evaluate the applicant for different jobs
- Job <–> Applicant
- Applicant <–> Applicant evaluation
In my Jobs table I can count the # of people that have applied to the job with a simple roll up. In my applicant_evaluation table I have a “Offered” column (single select yes/no). In my Jobs table I want to count the number of applicants who I’ve “offered”.
Is this possible?