filemaker pro 13 need to copy report results to a permanent table

Posted on 2014-08-30
Last Modified: 2014-09-16
I Have a layout that runs sub-totals (using a summry field) of a number of account classes items

Bookeeping 100.00
Office 550.00
supplies 312.00

with the numeric being the summary field of the accounting_class

I want to use them in a spreadsheet and think I need to store them in a new Permanent table

so I made a table called - summaries with record, account and total

Not sure how to script this to take the class-figures from the first report (layout) and loop them into new records in the second table - I see google stuff on exporting - importing etc but it seems like there should be a simple scripting method to do this - need the summary field results written to a permanent record in a single table

Any help, simple examples etc? Filemaker pro adv 13
Question by:drdocb
    LVL 9

    Accepted Solution

    no need to complicate matters.
    exporting really is the easiest, quickest, most standard way to do it :
    if you first run the report manually and export manually, filemaker will automatically use these settings in the new export script step.
    you can directly export to filemaker and select the correct destination table and fields so it probably will be 1 scriptstep.

    Author Closing Comment

    Thanks - sorry for the delay - we used this methodology with summary files and got what we needed. Lost track of time and would like to accept this solution

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    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…
    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…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    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…

    758 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

    13 Experts available now in Live!

    Get 1:1 Help Now