Creating a register system/table

[jagstangman]

Ok, firstly im sorry if this is in the wrong forum. I say this because my problem first begins with the tables but then i need to sort a problem out with the form aswell, but i will put it in here.

Here is the problem. Im sorry if im not too clear with this.

I need to create a register system E.G. A child comes into a club, he is registered. At the end of the session the child leaves the club. His depature is registered and his departure time is also recorded down.

Like a paper based school register but electronically.

How would I go about implementing this into a system?

Would I need a child table (with fields such as Child ID, Forename, Surname etc.) and a register table (not sure on the fields)?


k, this bit below probably goes in the forms section...

How would I get this to work on a form so there were boxes to check for arrival and departure, and when a button is clicked the depature time is filled in for each day of the term?

 

[cuttsy]

It all depends on what you need to record.

Yes you need a children table.
Depending on if there are more than one club you may need a Club table.
You might need a session table.
Then you could have a Register table


Children(ChildID, Firstname, Surname, DOB)
Club(ClubID, ClubName)
Session(SessionID, ClubID, Date, StartTime)
Register(ChildID, SessionID, ArrivalTime, DepartureTime)

...maybe.

 

[jagstangman]

thank you for the reply and help.

there is one club and the register needs to record childrens arrival and departure from the club. so ive been palying around with the table structure you gave in your reply but im not sure where to go from here.

This is possibly a forms forum question but... if ive got my register table what is the best way in implementing that into a form so the arrival time can be filled in as soon as they arrive and the departure time filled in as soon as they depart for each day the children are at the club

Thanks for your help

 

[Uncle Gizmo]

There is a sample database here that may provide you with some inspiration.

 

[cuttsy]

there is one club and the register needs to record childrens arrival and departure from the club.

In which case you do not need the club table.
If you need to store information about each session i.e. the session leader, the location, Notes etc then you will still need the Session table. If not and you only need the date then you can remove this table. Then you are left with:

Children(ChildID, Firstname, Surname, DOB)
Register(ChildID, SessionDate, ArrivalTime, DepartureTime)

Don't know if you are still working on this so let me know if you need any more help.

 

[jagstangman]

i am still working on this and thanks for your help cuttsy.Your suggestion has helped alot.

I also need a booking system so the children can book any dates they want in the year and it will work out the cost. and i want the register system to know if the child is ment to be at the club that day and if they arnt it is an absence.

i cant find a way to create a booknig system related to the register system that allows for any dates in the year to be booked