Placing information from multiple tables into a printed layout wihout using portals

Posted on 2006-05-31
Last Modified: 2010-04-27
I have one table that holds all orders. I have another table that holds items the person bought. I have another table that shows what the person paid.

How do I create a receipt (layout) that is based on the orders table and list all the purchased items and the payments below that?

I don't want to do this using portals- this is for printing and needs to hold infinite amounts of information.
Question by:macfundi
    LVL 28

    Accepted Solution

    1st, portals can be shrinked, so you can use a big one which can automatically shrink if not fully used, but I agree, it is not handy.
    My way to handle this kind of thing is to concatenate all the data I need from related records (items here) into a text field of the order at print time.
    to do that, I goto related records, goto to 1st record, store all fields I need from this record in a variable,
    goto next record, then do the same by defining $variable = $variable & [return] & [2nd record data...]
    etc... untill last related record.
    then to avoid the field to be broken at the bottom of the page, since you must make it bigger than a page, I use a merge field instead.
    Let me know of you'd like an example

    Author Comment

    Can you send me an example?
    LVL 28

    Expert Comment

    its is made for 3 pages max, but can be extended to n pages.
    waiting for yr comments if any.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    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…
    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…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    755 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

    19 Experts available now in Live!

    Get 1:1 Help Now