Would you have to create the sql Join Recordset before you run DA Wizard? I created a joined recordset on the results page, but it is creating a no data...
Well this may not be the most elegant way to work it but it works:
Details Order ID:
<?php $row_join['DetailOrderID'] = $row_WADAorders['OrderReferenceID'];
$newID = $row_join['DetailOrderID'];
echo $newID; ?><?php $query = "Select * From orderdetails where orderdetails.DetailOrderID = '$newID'";
$result = mysql_query($query) or die(mysql_error()); ?>
I can then call all the details from the orderdetails table and not need a repeating table on this page...