Ok,
I'm trying to put our job application process online, right now it's literally a printed doc files posted or emailed to applicants, very dated and slow now, and screaming out to be made better.
To that end, I have taken this on as a project but I have now started to hit a struggling point so I just want to check I'm going about this the right way etc.
okay so I have a main form called (wait for it...) Main.
Main has the information that an applicant would only enter one time. The Main table has the following fields:
Primary Key+autonumber ID
Short text, PostAppliedFor2
Short text, SURNAME
Short text, OTHERNAMES
Short text, ADDRESS
Short text, POSTCODE
Short text, EMAIL
Short text, PHONE
Short text, MOBILE
Short text, PersonalStatement
Boolean, WelshSpeaker
Short text, NoticePeriod
Boolean, UkWorkRestricted
Short text, UkRestrictions
In addition to this there are more tables for information that could require more than one entry (Specifically Employers, Schools,References and training courses)
I have the main table mapped out on a form with 5 buttons at the bottom linking to each of the smaller tables. And a finish&Save button.
I want to pass the value of the main.id field into a field called applicantID, as each smaller table may have more than 1 entry by the applicant, it seemed to make sense that I could query the database later for the applicantID, It would return an applicant's main form (All of it) along with each entry they made in the 4 smaller tables.
I'm having problems passing the value from main.id to xxx.applicantID, I know that I need to probably use the 'form on load' event so that the value is passed automatically based on the ID from main. I've tried various ways of doing it but I keep getting error code 2766 when I run it.
Am I doing this the right way? Anyone got any ideas on a better way or the magical syntax that I simply can't seem to get right.
My table names are:
Main
Education
Employment
Training
References
ID is the primary key from Main... each table has a number field called ApplicantID which is where I want to pass the value to.
Cheers
Jamie
I'm trying to put our job application process online, right now it's literally a printed doc files posted or emailed to applicants, very dated and slow now, and screaming out to be made better.
To that end, I have taken this on as a project but I have now started to hit a struggling point so I just want to check I'm going about this the right way etc.
okay so I have a main form called (wait for it...) Main.
Main has the information that an applicant would only enter one time. The Main table has the following fields:
Primary Key+autonumber ID
Short text, PostAppliedFor2
Short text, SURNAME
Short text, OTHERNAMES
Short text, ADDRESS
Short text, POSTCODE
Short text, EMAIL
Short text, PHONE
Short text, MOBILE
Short text, PersonalStatement
Boolean, WelshSpeaker
Short text, NoticePeriod
Boolean, UkWorkRestricted
Short text, UkRestrictions
In addition to this there are more tables for information that could require more than one entry (Specifically Employers, Schools,References and training courses)
I have the main table mapped out on a form with 5 buttons at the bottom linking to each of the smaller tables. And a finish&Save button.
I want to pass the value of the main.id field into a field called applicantID, as each smaller table may have more than 1 entry by the applicant, it seemed to make sense that I could query the database later for the applicantID, It would return an applicant's main form (All of it) along with each entry they made in the 4 smaller tables.
I'm having problems passing the value from main.id to xxx.applicantID, I know that I need to probably use the 'form on load' event so that the value is passed automatically based on the ID from main. I've tried various ways of doing it but I keep getting error code 2766 when I run it.
Am I doing this the right way? Anyone got any ideas on a better way or the magical syntax that I simply can't seem to get right.
My table names are:
Main
Education
Employment
Training
References
ID is the primary key from Main... each table has a number field called ApplicantID which is where I want to pass the value to.
Cheers
Jamie