Database and subdatasheets

[Guest]

I am trying to have information from multiple tables show up on one subdatasheet. Each table contains very similar data. There is a main table for "inactive candidates" and there are tables for each week for the "active candidates" (candidate name, company, dates, and so on). Is there anyway to get the inactive candidates table and all the weekly tables on one subdatasheet. Ideally I would like the main datasheet to be a complete list of names and then the subdatasheet to contain the history of each candidate. Any wisdom and insight is greatly appriciated.
Thanks,

 

[Pavel Romashkin]

Do you really have a table per week, containing the same information on
candidates? If so, you should use one table for all of them with a field
that would identify the week.
At this point you should use a union query to put together a summary of
all candidates. This union query will include all your weekly tables.
I don't know how to include the candidate information becasue you don't
list your table structure.
Good luck,
Pavel