Portal records - "Group By"?

[IrongateMachine]

Hello everyone,

I have a CDML solution that will display a page for a order. Each order has one or more parts that have been ordered and all are listed on this page. If any of the parts have been shipped, the tracking information is displayed, formated like this:

Date.............TrackingNumber...............PartNumber

All tracking info is listed together at the top of the page, each part on it's own line.

If multiple parts from the same order are shipped in the same package, all parts will have the same tracking/date so I would like to only display the tracking/date once per package. So instead of this:

4/1/04.............12345...............555

4/1/04.............12345...............111

4/1/04.............12345...............999

4/2/04.............44453...............222

4/2/04.............44453...............777

I want to display this:

4/1/04.............12345...............555

...................................................111

...................................................999

4/2/04.............44453...............222

...................................................777

The tracking database contains the fields TrackingNumber, OrderNumber, PartNumber, and Date. The portal is based on a relationship linking OrderNumber to OrderNumber

Anyone have any ideas on how to accomplish this? Any suggestions are appreciated, thanks,

FileMaker Version: 6

Platform: Windows XP

[Garry Claridge]

Here is some Javascript to try:

<script>var curr_date = "";

[FMP-Portal:tracking]

if (curr_date == "[FMP-Field:tracking::date]")

{ document.write("<tr><td></td><td></td<td>[FMP-Field:tracking::PartNumber]</td></tr>"); }

else 

{ 

document.write("<tr><td>[FMP-Field:tracking::Date]</td><td>[FMP-Field:tracking::TrackingNumber]</td<td>[FMP-Field:tracking::PartNumber]</td></tr>"); 

curr_date = "[FMP-Field:tracking::Date]"; 

} ; 

[/FMP-Portal]

</script>

All the best.

Garry

[IrongateMachine]

You've done it again Garry! thanks so much!