Starting from scratch

M

Mike Busch

I have a simple one table DB that I would like to start over. I will bring
over the data after creating it. I need a Database that I can have Name,
(along with other personal info)and show that this person has violated one of
our rules, need the date and what type of violation. But after all the info
is in (which includes a picture of person) we need to go back to this person
and add other violations and dates, then be able to print a report showing me
the violations and dates along with their information.
Any ideas. Thanks in advance.
 
A

Allen Browne

Mike, you need 3 tables here.

Person table (one record for each person):
PersonID AutoNumber primary key
Surname Text
FirstName Text
...

Violation table (one record for each kind of violation:
ViolationID AutoNumber primary key
ViolationName Text description of this violation.

PersonViolation table (one record for each time a person commits a
violation):
PersonID Number foreign key to Person.PersonID
ViolationID Number foreign key to Violation.ViolationID
ViolationDate Date/Time when this violation occurred.

Your interface will consist of a main form bound to the Person table, and a
subform bound to the PersonViolation table. In the subform, you can use a
combo box to select the violation committed. (The combo lists the violations
in the Violation table.) If a person commits another violation, you just add
another row to the subform, showing which violation and the date of the 2nd
offence on a 2nd row.
 
Top