FMPA 14. I have the table Master and the table Production, both related through field CODVAR. The table Production has several data into the following fields: CODVAR, TEST, WEEK, STEMS; I can correctly summarize some of these data with the summary built in functions of FMP (eg: Max(STEMS), Sum(STEMS)). My problem is I need a summarized field that shows me the content of field WEEK which corresponds with summary Max(STEMS) for each set of records of same TEST and same CODVAR.
Any help would be greatly appreciated. Thanks so much in advance.