Jump to content

SubSummary lookup in FM7


Toni
 Share

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

Recommended Posts

Hi everyone! Here is my problem

I have a database working in FMP 4.1, and in this one I have to files with a relationship. I use a portal to view the records on the other one, and below the portal i put the fields to resume the results of the portal. For this fields I use a lookup of the subsummary fields of the records beeing displayed on the portal. In FileMaker 4.1 this works fine. I mean you can make a lookup on the subsummary fields of another file, if you sort the records found correctly.

When I changed in FM7, something strange happened, the lookup was working again but instead of showing the subsummary of the records beeing browsed, it showed me the total subsummary of the all records of the file! And I can't find a solution to put it right.

Someone could say to use a relation instead of lookup, but I want to use a lookup because it speeds a lot the calculation, it makes nearly 7 to 8 time faster.

Any help on this? Hope I have explained it right. Thanks Toni

Link to comment
Share on other sites

Yes I've tried with the getsummary too. In fact that was the first thing I thought, sure it would have worked, but no result.

Link to comment
Share on other sites

In FMP 7 you have an auto-enter option to use a calculation. Have you tried that? You could use the aggregate functions with the relationship in the portal. Then sorting of the related records would not be required.

Link to comment
Share on other sites

He he, it worked! Thanks Ralph, I'm gonna do some more testing, but it is going to work for sure, thanks again.

Link to comment
Share on other sites

  • 4 weeks later...

Here I'm again with this problem which was solved with the autoentry option. After working on the database, yesterday I noticed something never seen in previous versions. So in the previous if you want to lookup on a subsummary field on another file, you need first to call the records for whom you want to lookup the summ.

But with FM7 you don't need this. FM7 will do the summ of the records you need using the value of the reference field you use to create the relationship between files. This is new and I think it is nice as an option. The only problem is you can't relookup if something has been changed in the file. But not much of a problem. I created a script which first will delet the record and then recreate it, and the new one will have the updated values.

Link to comment
Share on other sites

This topic is 6409 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
 Share

×
×
  • Create New...

Important Information

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