Randomblink
The Irreverent Reverend
- Local time
- Today, 14:52
- Joined
- Jul 23, 2001
- Messages
- 279
SELECT tbl_ProjectBasics.Proj_ID, tbl_ProjectBasics.Proj_Num, tbl_ProjectBasics.Proj_Title, tbl_Department.Dept_ID
FROM tbl_ProjectBasics
INNER JOIN ((tbl_Department INNER JOIN tbl_Employee ON tbl_Department.Dept_ID = tbl_Employee.Dept_ID)
INNER JOIN [tbl_LINK_ProjectBasics-Employee] ON tbl_Employee.Empl_ID = [tbl_LINK_ProjectBasics-Employee].Empl_ID) ON tbl_ProjectBasics.Proj_ID = [tbl_LINK_ProjectBasics-Employee].Proj_ID
ORDER BY tbl_ProjectBasics.Proj_Num;
I am showing the connections between four tables below:
--------------------------------------------------------------
tbl_ProjectBasics.Proj_ID
- to -
tbl_LINK_ProjectBasics-Employee.Proj_ID
--------------------------------------------------------------
tbl_LINK_ProjectBasics-Employee.Empl_ID
- to -
tbl_Employee.Empl_ID
--------------------------------------------------------------
tbl_Employee.Dept_ID
- to -
tbl_Department.Dept_ID
--------------------------------------------------------------
Well, I am using this SQL code as the ROWSOURCE for a listbox.
I want to Display ALL the Projects from tbl_ProjectBasics...
BUT
I want to have a combo box on the form where the ROWSOURCE is the tbl_Department...
Then, if you select a Department, it will use that as criteria for the one listed above...
Can you help me...?
FROM tbl_ProjectBasics
INNER JOIN ((tbl_Department INNER JOIN tbl_Employee ON tbl_Department.Dept_ID = tbl_Employee.Dept_ID)
INNER JOIN [tbl_LINK_ProjectBasics-Employee] ON tbl_Employee.Empl_ID = [tbl_LINK_ProjectBasics-Employee].Empl_ID) ON tbl_ProjectBasics.Proj_ID = [tbl_LINK_ProjectBasics-Employee].Proj_ID
ORDER BY tbl_ProjectBasics.Proj_Num;
I am showing the connections between four tables below:
--------------------------------------------------------------
tbl_ProjectBasics.Proj_ID
- to -
tbl_LINK_ProjectBasics-Employee.Proj_ID
--------------------------------------------------------------
tbl_LINK_ProjectBasics-Employee.Empl_ID
- to -
tbl_Employee.Empl_ID
--------------------------------------------------------------
tbl_Employee.Dept_ID
- to -
tbl_Department.Dept_ID
--------------------------------------------------------------
Well, I am using this SQL code as the ROWSOURCE for a listbox.
I want to Display ALL the Projects from tbl_ProjectBasics...
BUT
I want to have a combo box on the form where the ROWSOURCE is the tbl_Department...
Then, if you select a Department, it will use that as criteria for the one listed above...
Can you help me...?