Calculating Totals from other tables

[munday63]

I am creating a dream team database. I have a table for Goalkeepers, a table for defenders, a table for midfielders and a table for strikers. Each table includes player ID(Primary Key), Player Name, Club and Value.

Their is also a table with the Dream Teams. These include columns where the user chooses 1 goalkeeper ( from the goalkeeper table via lookup), 4 defenders (same way), 4 midfielders (again same) and 2 strikers (same).

What i am trying to do is to create another column which calculates the total value of all the players chosen in the previous columns but cannot figure it out.

Hope someone can help

 

[PHV]

Your database is far from normalized.
You may find this of interest:

http://www.abcdataworks.com/fundamentals.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244