summaries

[rome33]

I have a main database with points for each record. Then I have another table or separate database with 7 different user types.

you can choose the user type and amount of points in the main database but I can't seem to get a summary of points/per user type in the user database. I tried using the sum(field) but it wont update across the tables/databases. I think this is a relationship problem but i I don't understand relationships well enough to know what is the problem. Can anyone helpe me? In the main database it is linking to the user type database and the user type database is also linking to the main but for some reason the totals wont update across databases.