March 16, 200520 yr Author 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!
March 16, 200520 yr 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!
March 16, 200520 yr Author 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!
March 16, 200520 yr 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
March 16, 200520 yr 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
March 16, 200520 yr 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
April 14, 200520 yr Author Steve - sorry for taking so long to look at this... OK, subsummary is not something I
Create an account or sign in to comment