11 Replies Latest reply on Nov 16, 2009 12:27 PM by raybaudi

    Combine Excel Records into ONE Filemaker record?

    dbrouse

      Title

      Combine Excel Records into ONE Filemaker record?

      Post

      My Excel spreadsheet has data like this:

       

      Name     Job       ID        Product     Quantity 

      John       239      023       42H            1

      John       239      023       34B           2

      Mark       239      029       42G            1

      Lisa        239      035       42P             2

      Lisa        239      035       42W            1

      Tim        239      039       42B            1

       

       

      The ID# is unique...name/job/product are not unique. 

       

      I'd like to import this CSV file into FM Pro 10 and have John's record show that he order both product 42H and 34B but I don't want (2) reocrds for John. 

       

      Is there anyway to do this? 

       

      I'm a relative beginner when it comes to FM Pro but I have a little experience with db's. I'm currently using FM Pro 10.0v3 on OSX 10.6.2 (if that matters). 

       

       

       

       

      Thanks in advance...your assistance is greatly appreciated!