How to get body part to display multiple reocrds?

[JustinZ]

Hi

3 tables:

Customer

Purchases

Inventory

In the purchase table, there are multiple purchases per customer (by customer ID)

I want to create a summary in which i would be able to see the total purcahses of each customer, but when i create the layout in the customer table , the body will only display the the last purchase the customer has made

i have made a portal, which seems to work but i prefer it to be just the body istead, as i cant do calculations in the portal and do not like how the portal will always be 1 size and will not scale accordingly to rhe number of records

somethign liek this:

any help guys?

[Vaughan]

In Browse mode, View menu, View as List command.

[JustinZ]

but it only lists ONE of the purchases still

ive uploaded the files here

if anybody wants to poke around in them

http://ds-labs.com/PurchaseDB.zip

[Ender]

Justin, Please don't double post.

It wastes our time to work out your problems without the benefit of seeing the other steps that have been taken to resolve it.