Hi, I'm stuck again on my database. I realise that for a first try it's a little advanced, but it needs to be done....
Its for invoicing for our small charity run preschool. I'm stuck on adding the various different sessions.
Each child is booked for the same sessions each week. However these sessions differ from child to child. I have created a table to create invoicing periods, (say April -May 2016) then another table to create a list of dates we are open within that invoicing period. Ideally I wanted a calendar on the page which I could select all the days we are open, but I can't seem to manage to do that, so I have done the list of dates instead.
What I want to do is create a list of each child's bookings - eg Child 1 does Monday 9-1, Wednesday 9-3 and Friday 9-12, while Child 2 does Monday 9-3, Wednesday 9-12 and Thursday 9-12. After this I want to link these booked sessions with the list of dates we are open, and if the date on the list is a Monday, it would automatically add 9-1 for Child 1 and 9-3 for Child 2 so I can easily create an invoice from this.
I've tried so many ways, and I think I am probably missing something really obvious, but it's just not clicking with me.
Can anyone help? I hope my explanation is not too garbled! Does it help to post the whole database or does that take up too much space?
Thanks very much
Its for invoicing for our small charity run preschool. I'm stuck on adding the various different sessions.
Each child is booked for the same sessions each week. However these sessions differ from child to child. I have created a table to create invoicing periods, (say April -May 2016) then another table to create a list of dates we are open within that invoicing period. Ideally I wanted a calendar on the page which I could select all the days we are open, but I can't seem to manage to do that, so I have done the list of dates instead.
What I want to do is create a list of each child's bookings - eg Child 1 does Monday 9-1, Wednesday 9-3 and Friday 9-12, while Child 2 does Monday 9-3, Wednesday 9-12 and Thursday 9-12. After this I want to link these booked sessions with the list of dates we are open, and if the date on the list is a Monday, it would automatically add 9-1 for Child 1 and 9-3 for Child 2 so I can easily create an invoice from this.
I've tried so many ways, and I think I am probably missing something really obvious, but it's just not clicking with me.
Can anyone help? I hope my explanation is not too garbled! Does it help to post the whole database or does that take up too much space?
Thanks very much
