Combine field from 2 tables

[EllenG]

I need to create a valueslist that combines the Year field from 2 tables.

Financial contains Expense and Income records and Invoice contains Invoice records. Both tables use a transaction date.

I have a "Year plus All" defined in both tables, but I need to have a values list that will include the years from both tables.

For example, I could have invoices for 2009, but no expenses or income entered and maybe expenses for 2008, but no invoices. I would need both 2008 & 2009 in the valueslist.

Thanks.

[bcooney]

Why derive the Year values? Why not just have a hard-coded list of years?