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

Posted on 2008-11-08
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

    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


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now