I am currently working within Access 2013. I have built a Database that revolves around applicants submitting for a Job. The database is set up so that a person can apply for many different jobs, when the same person applies for a job through our website (uses JotForms) it automatically updates the database. I have a python script pulling the applicants submission information from an email which updates the database. The problem that I am running into is that within the database I have the applicants primary email set to no duplicates, thus not allowing the same person to apply for many different jobs as the python script is trying to create a new record within the database causing an error.
Within my Access form (VBA) what do I need to write to tell my database if the primary emails are the same only create a new record within the position applied for table that is related to the persons primary email?
Tables:
tblPerson_Information
Personal_ID (PK)
First_Name
Last_Name
Clearance_Type
Primary_Phone
Primary_email
Education_Level
tblPosition_Applied_for
Position_ID
Position_Personal_ID (FK)
Date_of_Submission
Within my Access form (VBA) what do I need to write to tell my database if the primary emails are the same only create a new record within the position applied for table that is related to the persons primary email?
Tables:
tblPerson_Information
Personal_ID (PK)
First_Name
Last_Name
Clearance_Type
Primary_Phone
Primary_email
Education_Level
tblPosition_Applied_for
Position_ID
Position_Personal_ID (FK)
Date_of_Submission
Last edited: