Hi,
I'm a pretty rookie at Access databases, but still trying and learning a lot, specially from this forum!
With this problem I am completely lost, so I would appreciaty your help.
I have a small database with 1 many to many join, so in my DB I made a linktable called 'Rooster' (=Schedule in English).
1 table: Dates (Dutch: data)
1 table: Projects (Dutch: Projecten)
1 table: Employees (Dutch: Werknemers)
The linktable 'Rooster' (Schedule) links the dates, projects, and employees together, I think I got the tables and joints correct (Tips are welcome!).
Some explanation:
-I can have multiple employees (werknemers) on multiple projects (projecten)
-I can have multiple projects on one date (datum).
-Each employee (werknemer) can work on several projects at one day/date
-Another date can have different Emplyees working on a certain project
My DB so far is attached to this post.
Now my problem:
My colleagues, would like me build a Main-form with ALL projects (as subforms?) on a certain date, and on those projects to see AND add/delete/change the employees working on that project.
(Mind you that the next day other people can be working on that project!)
Finally after many hours of trying, I got the form and subform and subsubform to show that data in one Form (only for one project so far, but that problem I will solve later***)
But I cannot find the solution to add records on the employees subsubform, nor on the projects subform!???
I have seen some examples at this forum about adding records to subforms, but never when it was based
on a link-table like mine. :-(
Anybody who can help me?
Thomas
The Netherlands
(***and for the die-hards, my next question: How can I show in this one main-form a number of X project-subforms when 'this date' has X projects running, and on the next day/date Y project-subforms, cause there are Y projects? Subforms must be positioned in 3 columns and plenty of rows)
I'm a pretty rookie at Access databases, but still trying and learning a lot, specially from this forum!
With this problem I am completely lost, so I would appreciaty your help.
I have a small database with 1 many to many join, so in my DB I made a linktable called 'Rooster' (=Schedule in English).
1 table: Dates (Dutch: data)
1 table: Projects (Dutch: Projecten)
1 table: Employees (Dutch: Werknemers)
The linktable 'Rooster' (Schedule) links the dates, projects, and employees together, I think I got the tables and joints correct (Tips are welcome!).
Some explanation:
-I can have multiple employees (werknemers) on multiple projects (projecten)
-I can have multiple projects on one date (datum).
-Each employee (werknemer) can work on several projects at one day/date
-Another date can have different Emplyees working on a certain project
My DB so far is attached to this post.
Now my problem:
My colleagues, would like me build a Main-form with ALL projects (as subforms?) on a certain date, and on those projects to see AND add/delete/change the employees working on that project.
(Mind you that the next day other people can be working on that project!)
Finally after many hours of trying, I got the form and subform and subsubform to show that data in one Form (only for one project so far, but that problem I will solve later***)
But I cannot find the solution to add records on the employees subsubform, nor on the projects subform!???
I have seen some examples at this forum about adding records to subforms, but never when it was based
on a link-table like mine. :-(
Anybody who can help me?
Thomas
The Netherlands
(***and for the die-hards, my next question: How can I show in this one main-form a number of X project-subforms when 'this date' has X projects running, and on the next day/date Y project-subforms, cause there are Y projects? Subforms must be positioned in 3 columns and plenty of rows)