I created a database program consisting of two files, one is a Project file and one is a Unit file. The purpose of the program is to have the user create a shelving installation project for a particular customer and to populate that project with different sized shelving units from Unit File. The Unit file differentiates each shelving unit by size, color, options. I am trying to create a raw material parts list to give to my purchasing agent so that he can buy material to produce the shelves. Here's an example. I have a project that has two similar shenvling units in it. Unit 1 is 12"W x 36"L x 74"H with 4 shelves . Unit 2 is 12"W x 36"L x 85"H with 6 shelves. The only difference is the height. I created a layout that has 2 sub-summary parts. Part one is sorted by a field called shelf_size and contains the summary field total_qty_shelves. Part 2 is sorted by a field called post height and contains the summary field total_qty_posts.

This is how the report looks in preview:

shelf size 12x36 qty shelves 4

shelf size 12x36 qty shelves 6

post size 74" qty posts 4

post size 85" qty posts 4

I want the report to group the identical shelves together. It should look like this:

shelf size 12x36 qty shelves 10

post size 74" qty posts 4

post size 85" qty posts 4

If the two separate shelf units are identical, I get the output that I am looking for. I am sure that someone can help me I am kind of new at this. Also, I simplified the example so I may not have provided enough information.

[ March 01, 2002, 06:00 AM: Message edited by: rimpoche ]

In your report, don't have a body area, just a subsummary.

This way it will just show you the totals.

Andy, thanks for the quick response. I do not have a body section in the report. Anymore suggestions. Thanks again.

OK,

can you email the files to me.

By changing the field that the subsummary sorts on to the quantity field, will then only give the total figure on one line

rimpoche, you answered your own question.

"Unit 1 is 12"W x 36"L x 74"H with 4 shelves.

Unit 2 is 12"W x 36"L x 85"H with 6 shelves.

The only difference is the height. "

Well, one difference is all it takes my friend, to make a sub-summary break it out separately. FileMaker has no intrinsic understanding of shelving installations.

You're either going to need to keep the height in a separate field, or sort on a calculated WidthLength field like this:

Left(shelf_size, Position(shelf_size, "L", 1, 1))