I have some nicely working relations between, let's say, products and orders. The orders are linked to one of the products, and shown in a portal (in the producst-file). What I would like to do is to be able to filter out a date-range in the orders, sum up the tolal order-value (of the found records) and print thes in a nice layout (in the products file). How do you do this?

- Is it possible to do a search for a date-range in the order-file, then go to products and the portal reflects the search in the orders-file (so that only orders within the date-range are shown)?

thanks!

One way to do this is with a global field, let's say gSelectedOrders. Make a relationship gSelectedOrders::products-order-id. Now make a list layout in the orders file with ONLY the order id on it, and a separate layout with just gSelectedOrders on it. Make a script that goes to the id list, copies all records, then goes to the gSelectedOrders layout and pastes. This puts all the order id's into the global field, one on each line. Now you just go to related records (show only related) and there you are!