Editing a field in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form that has a date field for a person that has violated one our
rules on a visit. This has their Name, address, Date of Violation, type of
violation and so on. When I first created this I did not know that there
could be multible entries for the same person. Is there a way to add to the
date field and put a new date, and update the violation per new violation. So
if a person comes in violates the first time he goes into the system. If he
comes in again I would like to add not update the persons ID by adding dates
to a record and the new or saem violation. Any ideas would help. Thanks in
advance.
 
I created a form that has a date field for a person that has violated one our
rules on a visit. This has their Name, address, Date of Violation, type of
violation and so on. When I first created this I did not know that there
could be multible entries for the same person. Is there a way to add to the
date field and put a new date, and update the violation per new violation. So
if a person comes in violates the first time he goes into the system. If he
comes in again I would like to add not update the persons ID by adding dates
to a record and the new or saem violation. Any ideas would help. Thanks in
advance.
Click to expand...

You may be making the common error of assuming that Forms contain
data. They don't, any more than my office window "contains" the Owyhee
Mountains. The data is stored in your Tables.

For this you should have at least three tables:

People
PersonID ' don't use names, they are not unique
LastName
FirstName
Address1
Address2
City
State
PostCode
<any other needed identifying information>

ViolationTypes
ViolationID Autonumber <primary key>
ViolationDescription <text or memo>

Violations
PersonID ' link to People
ViolationID ' link to ViolationTypes
ViolationDate Date/Time
<other information about this violation>

You would then use a Form based on People; you could use the form
"Find" or "Filter" capabilities to determine if this person has been
entered previously, and enter a new record if not. On the form would
be as subform based on the Violations table, with a combo box to
select the ViolationID.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top