Hi Dave,
First thanks for the outstanding support! Makes it easy to recommend your programs [:)]
Have a probably simple problem that I've tried to find a solution for so much that I'm now really confused! I have a table with many "class" records. I have another with the registration dates for each of those classes. Each can be edited by the user assigned to do such. What I'm trying to do is "import" the cooresponding class dates to display for a particular class at the bottom of the detail form. I've created a variable (list_record) in the class table (in this case called "evoc") that the user adds after adding the list of dates in the "registration" table which is the actual record number of the registration record. I've tried listing both in the Detail record for the class with hopes of displaying the dates from the registration table in the bottom but can't seem to make the registration table go to the class variable "list_record" to display the information in that [registration] record.
Here's what I have at the top of the class detail file:
<?php
require_once "/home/content/a/l/a/alameda582/html/_rtc2009/lib/viewer_functions.php";
list($evocRecords, $evocMetaData) = getRecords(array(
'tableName' => 'evoc',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$evocRecord = @$evocRecords[0]; // get first record
list($registrationRecords, $registrationMetaData) = getRecords(array(
'tableName' => 'registration',
'limit' => '1',
));
$registrationRecord = @$registrationRecords[$evocRecord['list_record']]; // have the registration table go to the list_record variable (1, 2... x) ??
?>
Then in the display in the class (evoc) detail I have:
<?php echo $evocRecord['content'] ?><br/>
<?php foreach (range(1,50) as $num): ?>
<?php $stringA = $registrationRecord["list$num"] ?>
<?php $toFind = " " ?>
<?php if ([url "mailto:!@$registrationRecord["list$num"]!@$registrationRecord["list$num[/url]"]) { break; } ?>
<option><?php echo strrev( strchr(strrev($stringA),$toFind) ) ?><br/></option>
<?php endforeach ?>
<?php if (!$registrationRecord): ?>
(Pending)<br/><br/>
<?php endif ?>
All I get is the first record dates from the registration table regardless of what class record is displayed. I just can't figure out how to have the registration table go to the class variable "list_record" to list the dates within that record.
I hope I wasn't too confusing...
Eric