Colby, John
JColby at dispec.com
Fri Nov 19 10:49:39 CST 2004
Many years ago I bought a library of functions for Turbo Pascal (I believe) - the person who wrote it had the title(s) President and Chief Bottle Washer. John W. Colby The DIS Database Guy -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Friday, November 19, 2004 11: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