Assign Preexisting Field to Current Field

[Dontremb]

Ok, here's my problem:

I have a many-to-many relationship set up like this:

tblPersonnel:
IDPersonnel
LName
Fname

tblVacancies:
IDVacancy
VacancyNumber
JobTitle

tblCompilation:
IDCompilation
IDPersonnel (Foreign Key)
IDVacancy (Foreign Key)
Hired Y/N


Next, I have a form that displays the Vacancies, with a subform of Personnel. All this works fantastic, until I try to assign a person to a new job vacancy.

Example: Job1: Suzie and Jack apply. This works fine, I can go into personnel tables and see that they have applied to this job, and I can go into the Job form, and see those two applicants.

BUT: Job2: If I want to show that Suzie ALSO applied to this one, this is where I get stuck. If I input her again, my table just makes a new one with a new ID.

I want to somehow be able to check for persons that already exist, or only be able to assign people to jobs that already exist. I just don't know how to go about beginning this.

 

[PHV]

I'd use ComboBox with LimitToList=True and a NotInList event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Dontremb]

PHV, I've been messing around with trying to get a combo box to work, but it doesn't seem to populate the subform correctly.

Also, I don't need to limit it to list, necessarily, I just need a way for the form to be able to use people that already exist before it tries to create a new person.