[AccessD] Form Sub form Problem

Are they paying them many salaries as well?  Unless they're storing a
job history, many titles doesn't make sense to me.

Charlotte Foust


-----Original Message-----
From: Joe Hecht [mailto:jmhla at earthlink.net] 
Sent: Thursday, November 18, 2004 11:11 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Form Sub form Problem


The Situation

On an inherited database the client has a single Employees form that
lists the with a text box for job title.

They want to have one employee with many job titles. I am trying to add
a sub form continuous view with a combo box.

 

 

SELECT stblEmpJobTitle.EmpID, stblEmpJobTitle.JobTitleID, [Job
Title].JobTitle

FROM [Job Title] LEFT JOIN stblEmpJobTitle ON [Job Title].JobTitleID =
stblEmpJobTitle.JobTitleID

WHERE (((stblEmpJobTitle.EmpID)=[Forms]![Employees]![EmpID]));

I need to not only show current job title but also assign new ones. When
I go to the next combo box it already has the existing job.

 

Looking for some help here please. 

 

JOE HECHT

LOS ANGELES CA 

jmhla at earthlink.net