E
ever
I have created a recruitment database and have the following tables employer,
candidate, vacancy and vacancy details. I am looking to use the vacancy
details table as a subform in both the employer and candidate forms so that I
can assign multiple candidates to one vacancy and have it update the
appropriate candidate record. I can get it to work with one candidate and
thought i would be able to use a multiple field list box but as I am using
the candidate ID from both the Candidate table and the Vacancy as the child
and master field I am unable to so do.
I am new to all this and have limited knowledge, would anyone have any
suggestions it would be appreciated?
candidate, vacancy and vacancy details. I am looking to use the vacancy
details table as a subform in both the employer and candidate forms so that I
can assign multiple candidates to one vacancy and have it update the
appropriate candidate record. I can get it to work with one candidate and
thought i would be able to use a multiple field list box but as I am using
the candidate ID from both the Candidate table and the Vacancy as the child
and master field I am unable to so do.
I am new to all this and have limited knowledge, would anyone have any
suggestions it would be appreciated?