Best way to use link field option

Please, please , please tell me that someone figured this out. I am doing the exact same thing with a real estate website that I'm working on and have come to the same problem where an agent is being displayed but its the same agent for every property. It looks as though I am missing one small detail to get this to work but I have no idea what it is. Here is my code:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php

require_once "/home/gselect/public_html/cmsAdmin/lib/viewer_functions.php";

list($listingsRecords, $listingsMetaData) = getRecords(array(
'tableName' => 'listings',
'joinTable' => 'agents',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$listingsRecord = @$listingsRecords[0]; // get first record

// show error message if no matching record is found
if (!$listingsRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}

?>




<?php foreach ($listingsRecord['agents.photo'] as $upload): ?>
<img src="<?php echo $upload['urlPath'] ?>" title="<?php echo $upload['info1'] ?>" />
<?php endforeach ?>
<br /><br />
<?php echo $listingsRecord['agents.title'] ?><br />
<?php echo $listingsRecord['agents.cell'] ?> <br />
<?php echo $listingsRecord['agents.email'] ?>