Hello! I am currently developing a database that needs to summarize the weight of certain products, by its product code, for a selected time period. The time period would be selected by the user, and a summary should be shown in the layout. I tried to create a self relationship to filter by start and end data, thus bringing all the records created within that period and then using another self-relationship to filter by product code. The summary shall only show one line per product code, but totalizing the shipping weight for the period selected. I tried to use the guidelines suggested in http://filemakerhacks.com/2011/10/18/summary-report-in-a-filtered-portal/. No luck at all.
Is there any other way to do this without scripting? The layout shall be iteractive to allow the end user to pick the dates he wants to evaluated the shipping weights and the layout should show the results right away.
Thanks for your advise!!!