A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

One table or Two?



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old July 3rd, 2009, 12:02 AM posted to microsoft.public.access.tablesdbdesign
DUNNER7
external usenet poster
 
Posts: 39
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.