M
marf
I have a table that contains information about projects going on in my company.
The ProjectsTbl links to a ResourcesTbl by ProjNum, it is a one-to-many
relationship.
ProjectsTbl
ProjNum
ProjDate
ProjStatus
ProjNotes
.... etc
ResourcesTbl - Basically it contains a list of the employees working on this
project and their depts
ProjNum - foreign key
ResourceID - autonumber
ResourceDeptName
ResourceLastName
ResourceFirstName
ResourcePhoneNum
I also have an EmployeeTbl that contains the names of all employees.
Basically what I would like to do is to create a form where I could enter the
resources assigned to a project. But I need the following functionality. I
want a drop down for the ResourceDept field where I can choose the dept. I
want the next box to show me only the employees that work for the dept that I
selected in the first box and not all 200 or so and then I need an "add
button" or something so I can assign another resource to the same project if
needed
In the ResourceDeptName field I need a drop down list that shows the dept so
I can choose one. In the second drop down I would like to show the employees
of
A project could have 1 resource (employee) or 15 resources assigned to it. I
would like to create a form
The ProjectsTbl links to a ResourcesTbl by ProjNum, it is a one-to-many
relationship.
ProjectsTbl
ProjNum
ProjDate
ProjStatus
ProjNotes
.... etc
ResourcesTbl - Basically it contains a list of the employees working on this
project and their depts
ProjNum - foreign key
ResourceID - autonumber
ResourceDeptName
ResourceLastName
ResourceFirstName
ResourcePhoneNum
I also have an EmployeeTbl that contains the names of all employees.
Basically what I would like to do is to create a form where I could enter the
resources assigned to a project. But I need the following functionality. I
want a drop down for the ResourceDept field where I can choose the dept. I
want the next box to show me only the employees that work for the dept that I
selected in the first box and not all 200 or so and then I need an "add
button" or something so I can assign another resource to the same project if
needed
In the ResourceDeptName field I need a drop down list that shows the dept so
I can choose one. In the second drop down I would like to show the employees
of
A project could have 1 resource (employee) or 15 resources assigned to it. I
would like to create a form