Hi. I have a dbase with 3 tables CANDIDATES (CandidateID), POSITIONS
(PositionID), & INTERVIEWS. Both the CANDIDATES and POSITION tables have a 1
to many relationship with the INTERVIEW table. The INTERVIEW table links the
other 2 tables. A CANDIDATE can apply for many POSITIONS just as a POSITION
can have many CANDIDATES. You can have a CANDIDATE without a POSITION as well
as a POSITION without a CANDIDATE. When you want to link a CANDIDATE with a
POSITION you use the CandidateID and PositionID in the INTERVIEW table. In
tables, everything works fine. The issue I am having is connecting CANDIDATES
and POSITIONS through a form.

My frmCandidate is tabbed. On the first tab are the fields from CANDIDATE
table. On the second tab is a subform with the fields from the INTERVIEW
table. I've included a combobox (with 2 columns) of the PositionName and
PositionID with a command button below it. I would like the user to be able
to use the combo box to select the position and then click the command button
to attach that Candidate to that Position. How can I do this?

Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1