1 Reply Latest reply on Apr 23, 2015 11:29 AM by philmodjunk

    Output With All Associated Records

    solent303

      Title

      Output With All Associated Records

      Post

      I'm trying to do an output to excel that shows the company name (from tbl_firm) and the associated employees at the firm (form tbl_employee). If a company has two or more employees they show up in Form & Table view, but not list view. Is there a way to make them show up in list view (as multiple lines) so as to do an excel output that shows more than just one employee at a company that has multiple. 

      FYI, I am using FMP/11. 

      Thanks - Dave 

        • 1. Re: Output With All Associated Records
          philmodjunk

          There are two possible output options IF you use export records from a layout based on tbl_firm, you can get:

          Firm1 fields    First Employee
                                 Second Employee
                                 Third employee
          Fimr2 fields First Employee
                                 Second employee

          But if you export from a layout based on Employee, you can get:

          Firm1 fields   First employee
          Firm 1 fields Second employee
          Firm 1 fields Third employee