Layout with Line Items

[aesart]

Greetings!

I posted this under Printing Issues, but maybe somebody in here knows what I need:

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!

I posted this under Printing Issues, but maybe somebody in here knows what I need:

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!

I posted this under Printing Issues, but maybe somebody in here knows what I need:

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!

[spb]

Maybe you could give some sample data. I'm not quite following you.

If what you are asking is what I think you are asking, then you want to display more than one PO & shipment ID for a single line item. Correct? Where I lose you is in mention of "columns."

If this is true, make the layout in the line item file. Make a subsummary sorted by vendor, then under that another subsummary sorted by line item. Under that, a body part containing PO & shipment ID fields. Do the two-level sort.

I do a lot of stuff like this, so if I misunderstood something, try again.

Steve Brown

[spb]

Maybe you could give some sample data. I'm not quite following you.

If what you are asking is what I think you are asking, then you want to display more than one PO & shipment ID for a single line item. Correct? Where I lose you is in mention of "columns."

If this is true, make the layout in the line item file. Make a subsummary sorted by vendor, then under that another subsummary sorted by line item. Under that, a body part containing PO & shipment ID fields. Do the two-level sort.

I do a lot of stuff like this, so if I misunderstood something, try again.

Steve Brown

[spb]

Maybe you could give some sample data. I'm not quite following you.

If what you are asking is what I think you are asking, then you want to display more than one PO & shipment ID for a single line item. Correct? Where I lose you is in mention of "columns."

If this is true, make the layout in the line item file. Make a subsummary sorted by vendor, then under that another subsummary sorted by line item. Under that, a body part containing PO & shipment ID fields. Do the two-level sort.

I do a lot of stuff like this, so if I misunderstood something, try again.

Steve Brown

[aesart]

Steve - sorry for taking so long to look at this...

OK, subsummary is not something I