Using drop down list to filter fields in List view
I'm making a advanced purchase order DB. I have a list of orders and, of course, different suppliers.
1). My goal now is to make my report layout in LIST VIEW to show me only orders to chosen supplier from a dropdown list menu.
2). but my second quite important goal is to sum total amount of all orders to this supplier.
I see it as repeating fields with data in body and control panel in footer.
There was a like question about it around (http://forums.filemaker.com/posts/bd4c57ef8d), but not public answer, unfortunately.
Do you have any ideas? Thank you.