Recent content by JohnLeeS

Currently there is a team of admin staff who records recruitment data in a rudimentary excel spreadsheet. Each row of the spreadsheet is a vacancy, and there are single columns for all the candidates associated with that vacancy, those who were successful, those who were hired. So multiple...

Fantastic, thank you Ken. Really appreciate all that

You might be right. I'll have a go like that, thanks!

Thanks Mike! Is there anyway to restrict the subform to either adding new candidates or selecting from a filtered merit list? It's probably not the correct way of doing things, but I don't think there's an issue eventually having duplicate records in Candidates_Tbl in practice.

Thanks again Ken My next issue, and forgive me if it's an obvious solution, is I'm unsure how to create the forms necessary. Currently I have a form for Vacancy_Tbl with a subform connected to VacancyCandidate_Tbl which contains a combo box for the candidate's name in Candidate_Tbl I've...

Thanks Ken and George, I see what you mean

Thanks everyone I think I'm missing something, how do I relate anyone from a reserve list with the vacancy they're ultimately successful for? Do I not need two fields linked to Vacancy_Tbl (one for the source vacancy, the second for the successful vacancy)?

Forgive me, but the file is a bit of a mess, but could I get some feedback on this data model? Because I need to know what vacancy each candidate originally came from as well as what vacancy they are ultimately successful for, I landed on thinking I need the above. The VacancyCandidate...

Thanks George!

Thank you! I'll take a look at this too Appreciate the help

Brilliant thank you, I'll give that a go!

Hi all, I'm pretty new to Access and while I can cope with a basic relational database, I've no idea the best way to structure the following: My task is to create a recruitment database to track vacancy campaigns, the candidates invited to interview, those successful at interview, and the...