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.
exex
PeterBaileyUkAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
Cascade delete will work only for one-to-many relations where "one" side is deleted. If you add  link from TblStudent_Session_link Link_ID to tblBalance it will work as expected. Try to check logic of relations
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
Your relationship between balance and student session is backwards.  The Link_ID goes in the balance table, not vice versa.
0
PeterBaileyUkAuthor Commented:
Thank you now working
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.