| re: Problem in programming waiting list for day care database
I assume your ChildByGroup table has GroupID and ChildID as the keys which
will prevent a child being entered in the same group twice. Why not add an
additional field State which would be Byte 1=Waiting, 2= day care, 3 =
Removed
If the rellationship between child and group was defined as cascading
delete, the all the ChildByGroup records should go when the child is
deleted.
A subform based on a query would show all the groups and status for each
child.
Phil
"Bartje" <b_delemarre@hotmail.com> wrote in message
news:f8e727d1.0312090707.36e892db@posting.google.c om...[color=blue]
> Hey,
>
> I am wondering what the best solution will be to program the following
> problem in access, the dutch 97 edition.
>
> I am developing a database for a day care centre (for my girlfriend).
> This database consist out of six tables, Child, Employee, Group,
> ChildByGroup, EmployeeByGroup (it must be possible to place a child or
> an employee in more then 1 group) and GroupSort (this table gives some
> information about the different kind of groups that exist in day
> care).
>
> I have explained that it is possible to place a Child in different
> groups, but it must be possible as well to place the child on a
> waiting-list (for the different groups). When the child leaves the day
> care it must be possible to leave the childs information in database
> in such a way that it can be erased easily later, by the system
> administrator. I would like that it is possible to see those three
> "states", waiting, day care and "removed", as different tables,
> without making a new table.
>
> I have thought about the following options:
> -Making a group waiting and "removed" in the group table and make a
> criteria in queries to see in which "state" the children are.
> -Making an extra field in the child table, that contain the
> information of the "state".
> -other options....
>
> What would be the best solution?
>
> Thanks in advance
>
> Bartje[/color]
| 
