If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One table or Two?
I am progressing with my student database, thanks for all help so far, my
next problem is this. I want to record student discipline infractions. This means that I will have a table to record each individual incident as reported by a staff member and the table will contain basic info, ie. time, location, rule violated, brief description of event. I will probably design a form based on the table for the staff member to enter each incident. I want this information stored into the table and sent to whomever will deal with the infraction & cc. to me (principal). Person who deals with the actual consequence/punishment for each infraction will have to enter relevant information ie. date, punishement type, length of punishment, parent contact made, brief description. This information has to be sent back to the referring staff member and stored in a table. Question is: Do I need two tables? ex. 1: "Violation" and 2: "Disposition"? Or can I have one table: "Discipline" and each party staff member and disciplinarian can enter their data piece into the specific incident on the one (1) table? If I need two tables the studentID would be the link between the two. Each incident and Each disposition would have it own unique number (auto number)? Thanks, Del Dobbs |
Thread Tools | |
Display Modes | |
|
|