how do i prevent data displaying on the next portal row in filemaker pro 9

Posted on 2008-11-08
Medium Priority
Last Modified: 2012-06-27
I have a portal in a purchase order form showing data from lines when I use a calculation field the field shows 0 values on the next portal row even though there is no data on the next row if i make the field auto enter by calculation this does not happen,as soon as i make it a calculation field again I have 0 in the next empty row again
Question by:DaryllvanG
LVL 28

Accepted Solution

lesouef earned 750 total points
ID: 22915798
a calc field is dynamic, everytime a layout is refreshed, it is recalculated.
an auto-entered value is recalculated only is any of the calc. members is changed.
you can decrease the recalc rate of a calculation if you have the "do not evaluate if all ref fields are empty" checked in the calc. window, bottom left.
personnally, I disable the "allow creation of records in this table via the relationship" feature as I hate this extra line hanging at the end of a portal and I use a script to create new related records together with a std "+" button.

Author Closing Comment

ID: 31514731

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Screencast - Getting to Know the Pipeline

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question