Hey i was wondering if its possible to have something like this:

For example: i have a customer table which has a relasionship to an orders table. what i want to do is when i expand each customer and see all their orders i would like to see how much money they have spent in total. if that isnt possible i would like to at least be able to add up the totals for a single order in which they ordered x amount of the same product. so just take the price of the product and multiply by the quantity.

soo is any of this possible? i have no idea really. if not let me know what i could maybe do to get similar results, thanks!

With Tables the answer is No.

Using queries with a Form or Report , the answers is Yes. This is what forms and report are great for displaying.