I am a recruiter making a database for myself to use to track all my candidates. I have a table with a list of candidates and another with a list of jobs. Right now I can search for jobs for a candidate in their area by zip code because I have a field on the jobs table that lists every hiring zip code with commas in between each zip. This works great with the search block, but leaves me manually linking all the jobs based on the search.
I would like some way to take the candidate’s zip code from their zip code field and search for an instance of that in the zip code field in every record of the jobs table. I want to do this to automatically link every job that hires in the candidates area.
Any ideas or guidance is appreciated! I’m on a mission to improve my processes and workflow.