Search Question

Results 1 to 2 of 2

Thread: Search Question

  1. #1
    Join Date
    Dec 1969

    Default Search Question

    What is the easiest way to allow users to search two fields, one in the parent table and one in the child table? My search results page loads the parent data into an array and then the linked "child" data into a recordset that loops. How can I allow the users to enter two search terms in this fashion?

  2. #2
    Join Date
    Dec 1969

    Default RE: Search Question

    Well, I think the standard way would be to JOIN the tables in your SQL statement and search both fields at once.<BR><BR>If that is not possible, because you don&#039;t want to join or some other reason, simply divide and conquer - have 2 search statements and 2 recordsets of results.

Posting Permissions

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