Joe Hecht
jmhla at earthlink.net
Fri Nov 19 10:50:54 CST 2004
Hey Charlotte, I doubt it but I have a signed work order and a third person paying me so I feel secure. Joe Hecht jmhla at earthlink.net 28g -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, November 19, 2004 8:39 AM To: Access Developers discussion and problem solving Subject: RE: [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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com