I have a MSAccess 2000 mdb where 2 tables must be connected with a fieldname "book_spoke".
This is what I have so far. Is it right? The purpose is to find within the search result all the book_spoke s and link with the proper url for each book_spoke.
Code:
<%
'Option Explicit
'Response.End 
Response.Buffer=false

Dim letter
Dim letterSQL
Dim str
letterSQL = "SELECT bible.book_spoke, "
letterSQL = letterSQL & "bible.book_spoke, "
letterSQL = letterSQL & "biblewheel_url.url "
letterSQL = letterSQL & "FROM bible INNER JOIN biblewheel_url "
letterSQL = letterSQL & "ON bible.book_spoke = "
letterSQL = letterSQL & "biblewheel_url.book_spoke "
'    letterSQL = "SELECT bible.book_spoke, "
'    letterSQL = letterSQL & "biblewheel_url.url "
'    letterSQL = letterSQL & "FROM biblewheel_url "
'    letterSQL = letterSQL & "INNER JOIN bible "
'    letterSQL = letterSQL & "ON biblewheel_url.book_spoke = "
'    letterSQL = letterSQL & " bible.book_spoke "

    strConn = GetConnectionString()

Set letter = Server.CreateObject("ADODB.Recordset")
    letter.CursorLocation = adUseClient

    letter.Open letterSQL, strConn, adOpenForwardOnly, adLockReadOnly
str = str%>

http://www.biblewheel.com
<%=letter("url")%>

<%

    letter.Close
    set letter = Nothing
%>
What I did was to make a parent child relationship within the "query" section in the mdb. But I'm not sure if I need to do other things.