Viewing multi tables in a single Portal

[Royce]

Good Day -

I have a customer file, I want to view past invoices for each customer in a portal in the customer file. I want to look at the customers entire history so I need to portal into Invoicng 2007, Invoicing 2006, Invoicing 2005, etc. and show all past invoice history.

What's the best way?

Thanks in advance,

Royce

[mr_vodka]

Why are there individual tables for each year? There should be an invoice table. In there you can just have a simple number field with calculated result that does Year ( InvoiceDate ).

Then use portal filtering to allow the user to access a pulldown menu or popup, and select a year from the menu. It should display the invoices for whatever year that the user selects. You can find many many posts with examples on here regarding portal filtering.

[Royce]

Sorry - the file names are yearly, the tables are all the same, "Invoicing".

Thanks for the tip.

Royce