Hello all, I'm trying to solve a problem, and need a bit of guidance in the easiest solution. I'm modifying an existing db to suit my needs.

In one table I have a list of items sold. So there will be anywhere between 1-10+ items (records) per transaction. Each item ordered is a separate record. Each "sale" has its own invoice number. For example, for invoice 0001, there could be 10 records in the sales history. So there will be 10 records and the constant will be the customer number and the invoice.

Then in the customer table, I would like to have a portal that lists just the total per invoice so I can see their past order history. No need to list every single item ever ordered, just a summary for each order.

My order page is sorted by invoice number with a subsummary after each invoice. That's the information I'd like to have shown.

Thanks very much!

No need to list every single item ever ordered, just a summary for each order.

Then are we in luck, this can be accomplished via the relations graph, and it's what usually is known as Ugo's method in these forums - study this:

http://fmforums.com/forum/showpost.php?post/266487/

...or watch this video:

http://www.filemakermagazine.com/videos/interface-summaries-viewing-totals-averages-more-free-video.html

--sd