0 Replies Latest reply on Apr 27, 2010 7:22 PM by KeshNair

    Combining Records into Filemaker

    KeshNair

      Title

      Combining Records into Filemaker

      Post

      Hi,

      Using Filemaker 9. I am new to filemaker.  

      We have a process where we imports files from another company into filemaker and then we use this data to make records for order acknowledgement and order shipment.

      We get a .csv file to import into filemaker, currently we get one .csv file with four records of the same order number.

      Each records has an order number has normal credentials like name address etc... and it has Product details like sequence ID field, product field, quantity field

      If I import a .csv file that has four records with the same order number and credentials but different Product details. How can I combine these 4 records into one record showing the same order number and credentials with four product details.

      I have already made fields in each record showing 4 product details (Sequence ID 1, Product1, Sequence ID2, Product2....etc)


      So when imports i get 4 Records

      Record1:

      Name:Jon
      Adresses: 67 horn st....

      Sequence ID: 35089
      Product: Cartridge 5
      Qty:6


      Record2:

      Name:Jon
      Adresses: 67 horn st....

      Sequence ID: 5556556
      Product: Cartridge 1
      Qty:4

      Record 3

      Name:Jon
      Adresses: 67 horn st....

      Sequence ID: 11002
      Product: Cartridge 6
      Qty:12

      Record 4
      Name:Jon
      Adresses: 67 horn st....

      Sequence ID: 0200
      Product: Cartridge 56
      Qty:20


      What I want to do is have one record like this.

      Name:Jon
      Adresses: 67 horn st....

      Sequence ID1: 35089
      Product1: Cartridge 5
      Qty1:6

      Sequence ID2: 5556556
      Product2: Cartridge 1
      Qty2:4

      Sequence ID3: 11002
      Product3: Cartridge 6
      Qty3:12

      Sequence ID4: 0200
      Product4: Cartridge 56
      Qty4:20

      I already have Sequence ID field, Product field and Qty field from 1-4 in each record, I just need help in combing the records/data into one record when I import it.

      Any help would be greatly appreciated.

      Many Thanks

      Kesh