5 Replies Latest reply on Sep 24, 2012 6:32 AM by beverly

    Excel Import-Unique Identifier-Dynamic Value List

    noriegae

      I am trying to import an excel file into Filemaker Pro 11 that holds over 20,000 auto records ever produced from 1990 to 2013.

      As you can see on the file attatchement, each record holds the Year, Make, Model, Trim. I can import the data, but I cannot seem to find a way to reference the data to CREATE A NEW RECORD on a new table. I figured creating a relational database using value list to dynamically pull the info; i.e. On the first pull down (Field:Year) I select 1990 it will ONLY pull the Model field vehicles related to that year and so on with the Model Trim.

       

      How do I go about importing this data into Filemaker Pro and creating unique values to reference conveniently?

       

      Like I said above I will attach an excel file with only 7,000 records (Originally >20,000 records) but I hope you get the idea.

       

      Any information will be appreciated.

       

      Thank You,

       

      Elvis Noriega