Recruitment Database Help

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.

Hi Tanya

I can help with this. Drop me a line at Thanks!

Wes Webber
(517) 325-3301

I sent you an email Wes with my number. I would love to hear from you ASAP.l

Hi Tanya,
This should be possible to implement and well within my area of expertise.
I would be happy to help you out on the same.
Feel free to reach out to me on
Best Wishes,