Finding all related records (and more)

[jugglingdan]

Apologies if this question is in the wrong place... I'm new to the site and this seemed the most appropriate forum.

I have created a database with a table of 'pupils' and a table of 'payments' that pupils have made. I have defined a relationship between the tables. I have created a field called 'ID' in both tables.

I want to have a field in my 'pupils' table that shows the total amount paid. I think the structure should be something like this:

1. Go to to 'payments' table

2. Find all records with 'ID' field value matching that of the 'ID' field value of the current record in the 'pupils' table

3. Take the value of the 'amount' field in each of those records and add together.

4. Return this calculated value to the 'total' field in the 'pupils' table.

My problem is that, being a beginner, I don't know how to implement this. Can anyone help? Thanks in advance.

[jugglingdan]

Ah! Worked it out! I just defined my 'total' field as a calculation and stuck in Sum (Payment::amount). Thanks anyway.