My approach would be that all open invoices, and closed invoices for the current fiscal/calendar year would be in one file and all closed invoices for prior years would be in one "history" file.

As you've found out, separate tables for every year complicates things.

Dale

>For example I have 4 same type tables which contains:
>1 table 1995 year's invoices
>2 table 1996 year's invoices
>3 table 1997 year's invoices
>4 table 1998 year's invoices
>
>And for example user wants to know some information from 96-97 years.
>How connect those tables into one to have virtually one table, not 4?
>
>Can I use views? Is there easiest way to do it?
>
>Giedrius