How to reference a foreign table ?

Results 1 to 2 of 2

Thread: How to reference a foreign table ?

  1. #1
    Join Date
    Dec 1969

    Default How to reference a foreign table ?

    I have 2 tables, 1 is the BOOK table, the other is the PUBLISHER table. When user fills in an on-line form for a particular book, he will need to choose a publisher from a list box. The problem is, how can I display the publisher information in the form once the user has selected from the listbox ? I don&#039t want to re-submit the selection to the server and refresh the form. Any effective way to achieve this ?<BR><BR>Thanks.

  2. #2
    peter T Guest

    Default RE: How to reference a foreign table ?

    When the user submit the form, you capture the book infor and use that book info to create a drop down list publisher info by <BR>opening a recordset and feed it to a list.<BR>For example,<BR> "select publisherinfo from publisher where bookinfo like &#039%" & request.form("bookinfo") & "%&#039",objconn<BR>if not rs.eof then<BR> response.write "&#060;select name=&#039&#039&#062;"<BR> while not rs.eof<BR> response.write "&#060;option&#062;" & rs("publisherinfo")<BR> rs.movenext<BR> wend<BR> response.write "&#060;/select&#062;"<BR>end if<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts