Unique fields

Discussion created by HB on Dec 23, 2016
Latest reply on Dec 23, 2016 by BruceRobertson

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