Could that overview look like this?
And so forth....
Week 24 (date: xxx - yyy)
Mon Tue Wed Thu Fri
Child1 X X
Child2 X X X
Child3 X X X
Also keep in mind that if a certain week is past the end-date of a childs contract it should not be displayed anymore
The tabular arrangement shown in your example can be produced from the same data model I had in mind for the example I posted. But my example shows a break down by group and yours does not. Do you want this overview to show to what group a child has been assigned? If so, how?
I was a bit too quick, but indeed my tabular data is showing yours.
however i want it the other way around. Show one whole week and see the occupation which consists of children.
I don't know what you mean by "see the occupation that consists of children".
You show this in your original post:
- Groups (room where the children will stay)
Which would seem to indicate that each enrolled child is assigned to a specific group and I am trying to determine if your overview should show the groups as well as the days of the week for which the child is expected(contracted) to attend.
These are key details that can determine what data model (tables and relationships) are needed in order to produce the desired results.
What I have in mind is a script that takes the contract's start date, end date and days of the week to generate a table with one record for each day that the child is expected to attend over the contracted range of dates.
My original report suggestion could then easily be produced as a summary report of those records.
Your "crosstab" style report can also be produced from the same table of records though the implementation details will require additional work to get it all on your layout the way that you want.
Child::__pkChildID = Contract::_fkChildID
Child::__pkChildID = EnrollmentDetails::_fkChildID
Enrollment details is the table that I am describing as having one record for each day that the child is expected to attend.
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
It should look something like this Excelsheet
Since I can't read your language, I can't really tell what you want to do with groups in your layout. And since FileMaker is not a spreadsheet program, trying to replicate a spreadsheet isn't always the best way to go for setting up your report.
My suggestion in my previous post remains unchanged. How you show group membership could be handled a number of different ways, but the tables and relationships would still work for you.
A row of 5 one row filtered portals on a list view layout where the row for each child is a sub summary layout part can be set up on a layout based on EnrollmentDetails. each portal filters the set of related records for a specific day of the week.
Ok, no probs you can't read my language :)
I'll start building with FM. I'm happy to post my result here for some 'pro' comment.