total per vendor in a calc

[Dataslinger]

OK, FMP 6! Say we have two datafiles.... one vendors, the other payments... in vendors we have a portal for showing the payments. In a 'status area' (browse mode)... along with date created/by and date modified/by... I'd like to show the total of payments per the vendor who's record we are viewing. Created a "total" subsummary field in payments, and then showed a merge field in vendors - no joy as it totals ALL vendor payments... I just want to show this vendor's payments. This is easy to do in a report, but want to show it on-screen in browse mode in the vendor's record. Thanks in advance.

[stanley]

Dataslinger:

You will need a relationship between the two files based on the key field for the vendor and the relevant field in the payment field. You can then have a calc field that is Sum(new relationship::total) which will show the total sales for whichever vendor record you are viewing.

-Stanley

[Dataslinger]

Stanley , perfect, thank you! - DS