>>How can I build a single record parent-child view with all the child values coming from the same record? The child record should supply date, amount and otherfield values, but all of them from the record with max(date). Using max(amount) and max(otherfield) gives values that aren't what I need. For this example, I need 6/1/2004, $90.00, Abacus.
>>
>>Date Amount Otherfield
>>01/10/2004 $115.00 Zephyr
>>06/01/2004 $90.00 Abacus
>>
>IF there is only going to be one record for a date and IF there are less than 5 fileds then I would do
>select max(dtoc(date))+str(amount)+otherfield
>and then parse out the results.
>
>Yes, this could be done in one select statement but I prefer to split things up like this. IMHO, makes it easier later on when it comes to debugging , commenting and the such.
It's a view, so I can't really split it. This is an ugly solution, but it works. I can't help but think there has to be an easier one.