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

    Unique fields

    HB

      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

      Tomato

      Lemon

       

      & later I will add more fields in the Unique table

       

      Thanks in advance