>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
>
That is good idea. Thanks. But...
Can I make one view from those two tables? "Union" of them?
>>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
Giedrius