Hi,
If you need to get account record associated with each truck record, just add a query to fetch that record inside your foreach loop.
This example assumes you're using CMSB version 2.08 or higher:
<?php foreach ($trucksRecords as $record): ?>
<?php $account = mysql_get("accounts", $record['accountNum']); ?>
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/