Table 1:
Holiness
Grace and Mercy
Peace (etc)
Table 2 is the same, so that song 1 could be about Holiness and Grace (in Table 1) and Mercy (in Table 2).
I have created these tables and a basic Query, but this only allows me to search for records from 1 table. In SQL View it is:
Expand|Select|Wrap|Line Numbers
- SELECT tblSongTheme.Theme, tblSongs.[First Line]
- FROM tblSongTheme INNER JOIN tblSongs ON tblSongTheme.ID = tblSongs.Theme
- WHERE (((tblSongTheme.Theme)="holiness"));