November 21, 200421 yr Newbies 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?
November 22, 200421 yr Author Newbies 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
November 22, 200421 yr 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.
Create an account or sign in to comment