7 Replies Latest reply on Dec 23, 2016 10:27 PM by BruceRobertson

    Unique fields


      How would I populate a table with one record for each unique field value in another table.


      Say I have a table called Produce with fields Type, Country and Cost and another Table called Unique with fields Type and cost


      Produce is full of records & fields ie


      Type Country Cost

      Tomato Cda $4

      Lemon USA $6

      Tomato US $2


      I want unique to be filled with




      & later I will add more fields in the Unique table


      Thanks in advance