C
Chris
I have a database which is tracking hours worked by employees in jobs.
Tables are employee (SIN primary), timesheetID (ID primary, SIN linked on
SIN), timesheethrs (DetailID primary, ID linked on ID, EntryDate, Amount,
Hours, IIAFID), IIAF (IIAF primary, IIAFID linked on IIAFID)
I have a form which uses a query to determine records for a particular
employee based on his SIN number and the weekending date. I can delete a
record from this form but it does not seem to delete the corresponding
record in the timesheetID table.
When I delete the record directly from the timesheetID it does delete the
corresponding related records.
I have checked cascade delete etc on the relationship. Is this a function of
using a Select Query as the basis of the form. Also the database is using
linked tables. When I view the relationships using the front end as opposed
to the backend database the diagram does not look the same as when viewed
directly from the database. Is this normal?
Thanks for any direction
Chris
Tables are employee (SIN primary), timesheetID (ID primary, SIN linked on
SIN), timesheethrs (DetailID primary, ID linked on ID, EntryDate, Amount,
Hours, IIAFID), IIAF (IIAF primary, IIAFID linked on IIAFID)
I have a form which uses a query to determine records for a particular
employee based on his SIN number and the weekending date. I can delete a
record from this form but it does not seem to delete the corresponding
record in the timesheetID table.
When I delete the record directly from the timesheetID it does delete the
corresponding related records.
I have checked cascade delete etc on the relationship. Is this a function of
using a Select Query as the basis of the form. Also the database is using
linked tables. When I view the relationships using the front end as opposed
to the backend database the diagram does not look the same as when viewed
directly from the database. Is this normal?
Thanks for any direction
Chris