Try using a list view layout with a sub-summary part or the header to show the site name. The items purchased would be listed in the body. Use a find to pull up all records for one site name. Sort by Site name to make the sub-summary part visible.
To learn more, look up "Sorting records by subsummary values" in filemaker's help system.
Thanks. It solved the problem. Now, I can't get each record to print by itself. I tested all kinds of page breaks, but non worked. They would like to print each sitename separate. Is that possible?
Try this layout arrangement:
[SubSummary when sorted by SiteName]
Item fields go here.
Select the "Page Break before each occurrence" option for the Sub-Summary part.
Use a find to pull up the records you need for your packing slips.
Sort the records by SiteName and print.
Thanks a lot!