Access 2000

  • Thread starter Thread starter AxessTerminated
  • Start date Start date
A

AxessTerminated

I am designing a database to handle accountability for about 2000
people. It tracks appointments when they're absent. I have a few
issues that seem rather simple, but I am not as well versed in Access
as I should be.

My biggest issue is when I delete an appointment by way of button from
a form, it deletes the person associated with it as well. The form
gets its data from a Query that's supposed to Filter by SSN. I have no
idea what's going on, because I get no error message, and the Delete
button was created by the wizard and has the standard delete command.
 
It sounds like the person is a child record to the appointment record and you
have cascading deletes turned on. Although you do need a reference to the
person in the appointment record, it should, in this case, not be set as a
relationship in the database relationships.
 
Back
Top