How to get the sum from a subtable to the main table

[Fedi87]

Hello!
I’m kind of new to access, but I’ll try to explain my question as good as I can.



I’m trying to make a sale database, where I have one table (Employee) with the columns: “ID” “Employee” “SoldCars” “TotalAmount” and then another table (Cars) which is related to Employee table and have the following columns in it: “Employee” “Cars” “Qty” “Price/Car”

How can I get the total amount of the cars in to the employee table, so that I can have a table with employee name and then total amount of cars and total amount he have sold, and when you click on the employer it would show all the cars he have sold. Is this possible?
I attached the access file to post, if anyone understand better from that.

Thanks in advance J

[recyan]

Do not know the functionality of your design. But at first glance, feel that design need to be looked in to again.

Thanks

[ItsMe]

If you are building a desktop application, rather than storing the calculated result in a table, I would calculate the result on the fly via a query or report and display the result in a form or report.