HB

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

Tomato

Lemon

 

& later I will add more fields in the Unique table

 

Thanks in advance

Outcomes