|
freeman24147 -> What's wrong with this code? (1/25/2008 3:00:19)
|
I am trying to use a normalized database method. I realized this is different from other attempts that have been successful, but I don't know why this does not work. Situation is this, I have a record with fields for Project_Manager, Program_Manager, and Project_Lead. All fields capture the Emp Id. I am using the follwoing sample code to pull back the Names of the employees. Works fine when I use only one field, say Program_Manager, but when I use Project_manager and Program_Manager fields, I get either blank fields, or with some tweaking, I get the same name in all fields. The code below results in the employee number displaying, but the Name field is blank:
SELECT Projects.Program_Name, Projects.Program_Manager, Projects.Project_Manager, Projects.Proj_ID, [FName] & " " & [Lname] AS [Prog Mgr], [FName] & " " & [Lname] AS [Proj Mgr]
FROM Projects LEFT JOIN Resource ON (Projects.Program_Manager = Resource.Emp_ID) AND (Projects.Project_Manager = Resource.Emp_ID);
I am creating this in Access, and then importing to FP2003. I think I need to specify something in the each specific type name field, but I don't know what.
Thanks in advance for any help.
Chris
|
|
|
|
