Linking info on tables

[domino3]

Hi

I have a two tables which I would like to link certain info on.

The first table has members on, each with their own ID no. The second table has fundraisng amounts raised by each member over a period of time. There may be more than one fundraising amount for any member. It also contains donations given. Is there any way to show the total fundraising amount from the fundraising table for individual memmbers in their own record on the members table.

Thanks

 

[AccessAce]

You will want to use a query to do this.

SELECT Members.MemberID, Sum(Funds.Amount)
FROM Members INNER JOIN Funds ON Members.MemberID = Funds.MemberID
GROUP BY Members.MemberID

The data will not be stored in the table, but calculated on the fly when needed. That way, you will always see the most recent information.

 

[domino3]

Thanks for the informaiton. However, is there any way of getting that data stored in the table and updated when further amounts are added. At the moment I am having to type the figures in manually.