Fields that will display all records of a ID? HELP

[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?

THANKS !:

[Ender]

Basing your sub-summary report on the Purchase table should get you what you want.

However, I'd suggest that you add one more table in there for the Order, between Customer and Purchase (maybe rename Purchase to be LineItem.) This gives each Customer multiple Orders, and each Order can then have multiple LineItems. This is a typical Purchase Order or Invoice design.

Your report would then be based on the LineItem table, where the Body part (if included) would show the individual LineItem. You can sub-summarize by Customer and Order.

[JustinZ]

I have done that

but it only lits ONE item (the lastest purchase) and not any others (when customers have more than one purchase)

is there some option that im not enabling?

i have gone to browse -> view as list

and sorted by the puchase tables'c customer ID

ive uploaded the 3 tables here:

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

if anybody wants to give it a go...

[Ender]

Your sub-summary reports are based on the Customer table, not on the Purchases table.

[Himitsu]

Justin, why do you have 3 files for that DB... that is a simple layout and could easily be handled in 1 file with 3 table. If you did that, you probably could navigate a lot easier and save you a whole lot of hassels. I will take a look and see, and if I have some time, maybe I will put it to one file with 3 tables.