[FX.php List] select fields and related fields

[Jane Chinn]

Hi,

Can someone advise me as to how I could do a search on a layout in a  
DB displaying three related tables. Here are the fields and  
relationships to find:

quick_time::Title
real_audio::Title
real_video::Title


quick_time::faculty_name
real_audio::faculty_name
real_video::faculty_name

The following select fields work with one relationship but I'm  
stumped as to how to do it with more than one:

<form method="post" action="searchmtis_result.php">
        <tr>
         <td align="right">Title: </td>
         <td><select name="quick_time::Title">
             <option value="" selected></option>
             <?
     foreach($listResult['valueLists']['TITLE'] as $key=>$value) {
     ?>
             <option value="<?php echo $value; ?>"><?php echo  
$value; ?></option>
             <?
     }
     ?>
           </select>
         </td>
       </tr>

       <tr>
         <td align="right">Faculty Name: </td>
         <td><select name="quick_time::faculty_name">
             <option value="" selected></option>
             <?
     foreach($listResult['valueLists']['FACULTY_NAME'] as $key=> 
$value) {
     ?>
             <option value="<?php echo $value; ?>"><?php echo  
$value; ?></option>
             <?
     }
     ?>
           </select>
         </td>
       </tr>

	  <tr><td/>
         <td><input type="submit" name="submit" value="Search  
Videos">&nbsp;
           <input type="reset" value="Clear"></td>
       </tr>
     </form>
   </table>

I appreciate any suggestions you can offer.

Jane