Jump to content

total per vendor in a calc


This topic is 6159 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6159 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.