Listing connected information inside a list

Hello,

I cannot figure out how to do this. Please help.

I am listing the accounts information and I would like to show the 'event_genre' field in a different table called 'event'.

So I tried using left join like this.

  // load records from 'accounts'
  list($accountsRecords, $accountsMetaData) = getRecords(array(
    'tableName'   => 'accounts',
    'loadUploads' => true,
    'allowSearch' => false,
'leftJoin'      => array(  
  // foreign table => local field (that matches num in foreign table)  
'event' => 'num',
 ), 
  ));

and on my html,

<div class="galleryList">
            <h2><a href="/en/galleryDetail.php?gallery=<?php echo $record['num'] ?>"><?php echo htmlencode($record['fullname_e']) ?></a></h2>
        <?php if($record['event.event_genre']  == 'tour'): ?>
        <div class="galleryDetail_event">
          <p>&raquo;Gallery Tour</p>
        </div>
        <?php endif ?>
        <?php if($record['event.event_genre'] == 'talk'): ?>
        <div class="galleryDetail_event">
        <p>&raquo;Gallery Talks / Lectures</p>
        </div>
        <?php endif ?>
        <?php if($record['event.event_genre'] == 'workshop'): ?>
        <div class="galleryDetail_event">
        <p>&raquo;Workshop</p>
        </div>
        <?php endif ?>
        <?php if($record['event.event_genre'] == 'exhibition'): ?>
        <div class="galleryDetail_event">
        <p>&raquo;Exhibition</p>
        </div>
        <?php endif ?>
        <?php if($record['event.event_genre'] == 'service'): ?>
        <div class="galleryDetail_event">
        <p>&raquo;Other Services</p>
        </div>
        <?php endif ?>
</div>


I am not getting the right result. The output becomes 'event' record num = 'account' record num.

What I wanted to do was to refer to the 'gallery' field's value 'num', which is a pulldown list on the 'event' section. 

Then, list the 'event_genre' field on the viewer.

The 'gallery' field's value is 'num' and the label is 'fullname'. 

How can I make this work?

Thank you,

Hiroko