Help with c# application from with database

[vanillathunder722]

Howzit guys i would like to know one thing.
I want to make a program and basically It must allow the user to enter fields such as: "Name", "Age", "Colour of belt", "Name of Club". Then after entering a whole bunch of data, the software must output a list of all the Kids who fall in the catogery 4-5years and in the various belt category (white,yellow,orange,green,blue to Black).

if anyone can give me info about how to set up my access database for that it will be nice. so far i know i'll have a User table and a Belt table. Not sure about the rest.

any info will be great
thanks!

 

[pilks]

I would have three

User
Belt
Club

You can manipulate SQL to create the age categories.
User table will foreign keys for Belt and Club
otherwise the table structure seems fine for what you want to do. it Seems like a basic application

 

[guest2013-1]

lol, I should have read this post first. "Club" makes a lot more sense in this context now. However my suggestion would be the same here as it would in the previous thread.

You might want to add a "timestamp" field to the "ClubClient_Table" (which would be BeltClient_Table in this case as well) I suggested. That way you can keep track of WHEN a person was graded into the next belt and from which club etc.

Keeping my previous suggestion (in the other thread you created with sql help) in mind, this will allow your program to allow for a client/user to change their clubs at any point in time (and you keeping record of the changes, also with a timestamp field perhaps) which you can then use in future to go:

"John Smith was a white belt on 2-Apr-1999 at Club Karate-jou-moer-Boksburg and was 5 years old"
"John Smith was a yellow belt on 15-Mar-2002 at Club Karate-My-handjies-kry-seer-Sandton and was 12 years old"

etc

Depends on how extensively your program will be used. I'm guessing it won't be the standard for all karate/judo/whatever centers. But it makes it flexible enough to handle that if it comes to that