Link to home
Start Free TrialLog in
Avatar of PeterBaileyUk
PeterBaileyUk

asked on

Relationship in access table wont cascade delete

In my form I can add classes and if i delete a student it cascade deletes successfully so I know my relationship between class sessions and the link table is ok, I can delete single or multiple students or the class session in entirety.
I have a balance table, every time I add a student to a class it updates that and takes away a credit.

I wanted to be able to cascade delete the balance record for that session if the student was absent or the session got cancelled.

So I put the balance ID into the link table too, that allowed me to create the relationship but when I delete the class session the cascade delete works as mentioned before ie the link table entries get deleted but not the balance entries in the balance table itself.

I must have the relationship wrong but I am not sure how to achieve this, the balance table does have the student FK in it too.

Ive added a picture of the relationships and also the class form too.
User generated imageUser generated image
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PeterBaileyUk
PeterBaileyUk

ASKER

Thank you now working