If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup query problem
I have a Projects database with the following tables (among others):
* Project (ID, ProjectName, ...) ** ProjectAssignments (ProjectID, EmployeeID, ...) ** ProjectStatusReports (ProjectID, ReportDate, ReportedBy, Status, ...) [ProjectAssignments] contains the employees a project is assigned to [ProjectStatusReports] contains status reports for a specific project My question is: how can I limit the contents of the [ReportedBy] lookup list only to those employees assigned to the specific project? A lookup query I created returns all the employess assigned to any project in the database, not only the ones related to the current project and the problem seems to be that I cannot reference somehow the current record in the table [ProjectStatusReports] |
#2
|
|||
|
|||
Lookup query problem
You need to do this in a form, not in a table.
See http://www.mvps.org/access/forms/frm0028.htm -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "vsiat" wrote in message ... I have a Projects database with the following tables (among others): * Project (ID, ProjectName, ...) ** ProjectAssignments (ProjectID, EmployeeID, ...) ** ProjectStatusReports (ProjectID, ReportDate, ReportedBy, Status, ...) [ProjectAssignments] contains the employees a project is assigned to [ProjectStatusReports] contains status reports for a specific project My question is: how can I limit the contents of the [ReportedBy] lookup list only to those employees assigned to the specific project? A lookup query I created returns all the employess assigned to any project in the database, not only the ones related to the current project and the problem seems to be that I cannot reference somehow the current record in the table [ProjectStatusReports] |
Thread Tools | |
Display Modes | |
|
|