Thanks, you take me back to my original question. If I am able to do this
with one table (infractions/dispositions) together.... can two seperate
people, 1: the reporer of the incident and, 2: the person who handles the
disposition enter data into the same table using two different forms. For
example I would design form that would enter specifics of the
infaction...form would be sent to admin (disposition part), person could view
infraction, hit command button, pull up form to enter disposition, hit enter,
and disposition information is entered onto same row as infraction
information in the fields set aside for disposition data in one table??

It would be nice to be able to flogg a child every once in awhile.


Del

"John W. Vinson" wrote:

On Thu, 2 Jul 2009 16:02:01 -0700, DUNNER7
wrote:

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

Part of the question is: will each violation involve one and only one
disposition? Or might a student have (say) detention, an essay to write
explaining why he'll never do it again, and flogging? (oops, showing my
age...)

If only one disposition will ever be needed, one table will do; if you want to
allow for the possiblity of multiple outcomes, followups, etc. then a second
table in a one-to-many relationship would be more appropriate.

--

John W. Vinson [MVP]