Okay. That's a different animal. This is a little kludgy, but it will work,
except for that case that has one more tracking number than the
number of expressions you allow for:
Assuming a practical maximum of, say, 3 tracking numbers, you could
put four expressions in the report, and have them evaluated only in the
page footer:
rvTrk1 = (MIN (Tracking_number)) IN othertable WHERE InvoiceNum =
InvoiceNum
rvTrk2 = (MIN (Tracking_number)) IN othertable WHERE InvoiceNum =
InvoiceNum AND Tracking_Number > .rvTrk1
rvTrk3 = (MIN (Tracking_number)) IN othertable WHERE InvoiceNum =
InvoiceNum AND Tracking_Number > .rvTrk2
rvTrackList = (.rvTrk1 & .rvTrk2 & .rvTrk3)
Locate rvTrackList in the page footer.
Bill
On Thu, 30 Aug 2001 14:19:57 -0700, Dan Goldberg wrote:
>I have details from another table already printing in the detail section.
>
>What I have is like:
>
>[PAGE HEADER]
>
>customername
>customeraddress
>invoicenumber
>
>
>[DETAIL]
>qty_ordered
>item_description
>
>[PAGE FOOTER]
>
>trackingnumbers(variable which is rows of a column in a different
table)
>
>
