I am creating a Master Bill of Lading report and need help with a prticularly sticky issue. The report will be broken down by Vessel, Ship Date, Destination and Container. Each item in the container will then be listed.

This is the problem. Every item has an SED number and what I'd like to do is create a footer that is printed whenever the destination changes. In the footer I would like to print a calculated field of the all the SED numbers concatenated together for that destination. Each Vessel and Ship Date can have numerous destinations, so I will start a new page every time the destination changes.

How can I go about separating these SED numbers for each destination?

Thanks

the Mad Jammer

the Mad Jammer,

I believe you will have to do this through two fields in destinations table that is related the items being shiped to that destination (one to many relationship). Create a value list which shows only related items starting from the destinations table. Set the first field (text field) with the value list items. The second field should be a calculation field that substitutes the carraige return with ", ". Place this field in the footer of your print layout in the items file and sort by destination. See attached example. You will need to loop through the destination records and set the value list field each time you run the report to ensure the list is up to date. Well I guess I can't attach the file. I do not have Winzip on this computer, only Winrar. Hey one for the administrators, change the allowable attachment file extensions to include *.rar Any way I hope you get the idea.

The Mad Jammer,

I'm at my other computer now (with Winzip). see attached files. In reality I imagine you will require another file for containers related to both destination and items but the theory is the same.

The Mad Jammer,

I'm at my other computer now (with Winzip). see attached files. In reality I imagine you will require another file for containers related to both destination and items but the theory is the same.

test.zip

Thanks onefish.

Just got power back after Katrina sauntered through South Florida. Glad I don't live in New Orleans and thereabouts. Hoep they'll be OK.

Just downloaded the zip. Let me muddle with it for awhile and I'll let you know if this will do the trick.

the Mad Jammer

BTW,

If I simply plopped the SED number field with the other fields on the layout, could I somehow just recalculate the string whenever the footer is invoked?

All of the records being processed have a Vessel, Ship Date, Destination and Container already filled in. SED numbers are unique anyway, so each record in the found set would have its own SED number. The string simply needs to be recalculated on the fly. Perhaps thats a little far out there for FMP.

Jammer