I'm in the process of setting up a new inventory/invoice system for a clothing company.I apologize in advance for the crude example.

I'd like the look of the invoice to be as follows:

style size 32 34 36 38

J455 cargo pant olive 1 2 2 3

J456 cargo pant khaki 2 2 2 2

As opposed to:

J455 cargo pant olive 32 1

J455 cargo pant olive 34 2

J455 cargo pant olive 36 2

J455 cargo pant olive 38 3

J456 cargo pant khaki 32 2

etc...

My main goal is to avoid multiple pages for an invoice while also being more coherent.

I realize this post is a bit vague, but if you have any bit of advise it would be greatly appreciated.

FileMaker Version: 7

Platform: Windows XP

Create a separate quantity field for each size, is one way to do it.