G
Gary
I have used Forms and subforms to give me the subdatasheet (expand & collapse).
This is what I want to do:
1) A table which has a list of projects, and 12 months of manpower
allocation (which is a number that indicates head count). Since this is a
table, there are multiple entries for a given project because of subprojects
names). So I made a query that groups the projects together under projects,
and sum up the manpower for the 12 months. So I get one entry per project.
2) I have another table that has the same projects and a field for
employees. When expand out on the form, I see the subform with the employee
being empty currently. I am able to enter data (like names in the field).
As soon as I collapse the subform, and expand again, the employee names are
gone. If I look at the table I see it. The two forms are linked via
project (the name).
3) This is what I want, when I select the project, I want to expand on it
and update or add employee names to the query or table. When I go back and
expand, I want all of the employees shows in the subform under the selected
proeject.
Can someone please help!!
Thanks,
Gary
This is what I want to do:
1) A table which has a list of projects, and 12 months of manpower
allocation (which is a number that indicates head count). Since this is a
table, there are multiple entries for a given project because of subprojects
names). So I made a query that groups the projects together under projects,
and sum up the manpower for the 12 months. So I get one entry per project.
2) I have another table that has the same projects and a field for
employees. When expand out on the form, I see the subform with the employee
being empty currently. I am able to enter data (like names in the field).
As soon as I collapse the subform, and expand again, the employee names are
gone. If I look at the table I see it. The two forms are linked via
project (the name).
3) This is what I want, when I select the project, I want to expand on it
and update or add employee names to the query or table. When I go back and
expand, I want all of the employees shows in the subform under the selected
proeject.
Can someone please help!!
Thanks,
Gary