Hi Guys, full disclosure, this is an assignment for college. However I'm stuck on the final piece of the puzzle. I have a built a database built around a recruitment process. i.e. Applicant details, Job Details, and interview Details. However it is important that an applicant can apply for many jobs and can receive many offers but he/she can only accept one job. I'm struggling to incorporate this into my database. Is there a way of using validation in a field that does not allow the same USER id to select "Yes" if the user selected yes already to accept another job offer?.
Any advice would be much appreciated.