Data for columns on reports

[aesart]

Greetings!

It took me awhile to figure out the ins and outs of a line items file, but some of the posts in here have helped me get out of the "repeating field" and it's confusions. But now I can't figure out something else:

To make this as easy as possible, If I can find the set of desired items in a line items file, how do I set up a print layout that is based on other criteria in the items?

For example, in a vendors file, sorted by item number, I need to display the status of different orders and inbound shipments. I can find for the vendor and sort by the part numbers, but how do I configure the columns for different PO numbers and shipment ID's?

Currently we have all the vendor files separate, which helps with the problem, but I'm convinced there is a way to simplify this information and keep down the size and complexity of the database. I feel there is a concept I'm missing here.

FileMaker Developer 6, Server 5.5 (for now) Mac and Windows 2000

Thanx!

[aesart]

Greetings!

It took me awhile to figure out the ins and outs of a line items file, but some of the posts in here have helped me get out of the "repeating field" and it's confusions. But now I can't figure out something else:

To make this as easy as possible, If I can find the set of desired items in a line items file, how do I set up a print layout that is based on other criteria in the items?

For example, in a vendors file, sorted by item number, I need to display the status of different orders and inbound shipments. I can find for the vendor and sort by the part numbers, but how do I configure the columns for different PO numbers and shipment ID's?

Currently we have all the vendor files separate, which helps with the problem, but I'm convinced there is a way to simplify this information and keep down the size and complexity of the database. I feel there is a concept I'm missing here.

FileMaker Developer 6, Server 5.5 (for now) Mac and Windows 2000

Thanx!

[aesart]

Greetings!

It took me awhile to figure out the ins and outs of a line items file, but some of the posts in here have helped me get out of the "repeating field" and it's confusions. But now I can't figure out something else:

To make this as easy as possible, If I can find the set of desired items in a line items file, how do I set up a print layout that is based on other criteria in the items?

For example, in a vendors file, sorted by item number, I need to display the status of different orders and inbound shipments. I can find for the vendor and sort by the part numbers, but how do I configure the columns for different PO numbers and shipment ID's?

Currently we have all the vendor files separate, which helps with the problem, but I'm convinced there is a way to simplify this information and keep down the size and complexity of the database. I feel there is a concept I'm missing here.

FileMaker Developer 6, Server 5.5 (for now) Mac and Windows 2000

Thanx!

[The Mad Jammer]

try creating a new Columnar/List report layout and select the "Report with grouped data" option. This will allow you to specify breakpoints on the report when the value of the grouped data field(s) changes.

The Mad Jammer