I think I may now understand what you are trying to do....but there again I may well be completely wrong!

You have a "printing application" that requires a table as its record source.

In order to get the details for the print you need to provide some data and which book/page to print it on...each page has 10 records.

so...I think your TABLE_RECORDS should look like thie

IDbookpage number

1111

2112

3113

4114

5115

6116

7117

8118

9119

101110

11121

12122

13123

etc

eg...records 11 to 20 will print on page twp...and so on

for some reason you have split your data into separate tables...and now wish to join it back together by ID..is this correct?

Have you still got the original table imported from MS Access? ...becasue I have a feeling that may already have all the details you need...ie before you split it out.

You may need some help in concatenating (joining) columns and formatting dates to meet your print requirements, but before we go there...is this a correct interpretation of your problem?