I am developing an invoice history file for my company. Invoices range from 1996 -2005. I have created tables for each year (both for header and related line items ).

What I want to do is use a user interface with two portals (header and line items). I want to enter a year and customer number on that page and have the correct year and related invoices appear in the portals below. Can this be done without dumping all of the records into a single table? Can a portal be controlled by a variable?

A portal can only show records from one related table.

You should combine your invoice data into one table, and your line item data into another. You can filter which records to show by adding a year criteria to your finds and relationships.

you probably shouldn't have created separate tables for each year. From a data standpoint it doesn't make sense. All those tables store the same kind of data.

If you had only one table for all invoice data (and one for items) then you could filter the portal based on a year.