AnsweredAssumed Answered

Associating Multiple Records

Question asked by StevenDeNeal on Jan 10, 2013
Latest reply on Jan 10, 2013 by StevenDeNeal


Associating Multiple Records


     I am creating a quick search database for all of our invoices by exporting my sales journals from my accounting software. The interesting thing my accounting software does when it exports as .CSV is it makes every invoice line item its own record. So to give an example:

     Record   Cust_ID    Invoice    Description

          1           ABC          123          Part# 321

           2          ABC          123             Labor

           3          ABC          123               Tax

     So, when I query a particular invoice or customer ID, I come up with with a dozen or so records which are really just one invoice. Is there a way to have FM associate all records with the same invoice number as a single record?