Loop through Loop (Inner Loop)

[Luthius]

Guys
I would like to know how can I create a loop through the records of my table where I can initially "print" the values using debug.print method grouped by the foreign key.

tblBook
idBook
fkAuthor
BookTitle

So the loop will check by author (fkAuthor) I mean for each author will print its book.
For each fkAuthor in my table print the book title.

How Can I do it

 

[xenou]

Hi,
You would use SQL for this:
PSEUDOCODE

select 
	A.Author, 
	B.BookTitle
from 
	Authors A
	inner join Books B
	on A.Author = B.Author
order by
	A.Author,
	B.BookTitle

 

[Luthius]

But if instead SQL use a code to do it. How could it be?

 

[xenou]

No reason to use code for it when SQL will do. That's what SQL is for. If you want to know how to use code then you would use DAO or ADO recordsets.

Examples:
MS Access Using DAO Recordsets
Looping Through a Recordset | Access All In One

ADO and DAO do the same thing, but are slightly different in how you write the code and use the recordsets.