export from two separate found sets
I have two separate tables that are related by the person ID. One table tracks people selected for tasks in each year. The other shows these peoples' test scores each year. For the year in each table I use a year field and populate each with the same drop-down value list.
What I want to do is create a found list for a specific year in the tasks table AND create a found list for only a specific year in the test AND be able to export only this data to Excel. In other words, all people selected for a task in 2009 AND all these peoples' test scores for 2009 only.
Can I export two found sets to the same spreadsheet?