Hello and thanks for reading.
I set up an inventory database, with each item its own record. Each record has three category fields since each item can belong to up to three categories.
In Layout, I set up a subsummary part sorted by short description and the inventory looks good, it shows one of each record but it's the whole inventory rolled together.
I'd like to have the Layout produce a pdf and printed catalog, organized by these categories.
ie, first pages are Widgets, then Thingamabobs, then Whatchamakallits and so on.
Unfortunately I'm now discovering that when you use a subsummary it can only be based on one field. I tried multiple subsummary parts thinking I could get each grouping that way but it's not working.
What's the proper way to do this? Do I need another table with categories, instead of three fields per record?
I'd like to resolve this asap as we have a big trade show starting Tuesday...