One To Many Lost My Way?

E

Elvis72

I have a subform in a main form that is link together in the following way:

Mainform - TblConstructionServices
Job/ProposalNo - primary key

Subform - TblProjectInformation
ProjectID - primary key
WorkerID - links to tblresume
Title ID - links to tblstaffrequirements
Job/ProposaNo - links to tblconstructionservices

So, the subform is this:

SELECT TblProjectInformation.ProjectID, TblProjectInformation.[Position
Title], TblProjectInformation.[Hourly Wage], TblProjectInformation.[Title
ID], TblProjectInformation.WorkerID, TblProjectInformation.[Job/ProposalNo],
TblProjectInformation.[Requisition No], TblProjectInformation.[Mobilization
Date], TblProjectInformation.[Demobilization Date], TblProjectInformation.[HR
Classification], TblResumes.[First Name], TblResumes.[Last Name],
TblResumes.[Cell Phone], TblResumes.Email, TblResumes.[Resume Link] FROM
TblStaffRequirements INNER JOIN (TblResumes INNER JOIN TblProjectInformation
ON TblResumes.WorkerID=TblProjectInformation.WorkerID) ON
TblStaffRequirements.[Title ID]=TblProjectInformation.[Title ID];

What my problem is I need to be able to create a record in the subform when
someone selects a Position Title from the Title ID combobox.

Right now it only creates a record when you select a Worker from the
WorkerID combobox.

But I need to create the position before it is actually staffed.

So, I'm sure I have done something to point it to WorkerID but I cannot
figure it out?

Your time and help is GREATLY appreciated!~
 
E

Elvis72

The above is actually creating the record...but its not pulling it back up
when you re-open the form?
 
Top