AnsweredAssumed Answered

Combining fields from different records

Question asked by realgecko on Aug 26, 2016
Latest reply on Aug 28, 2016 by realgecko

Dear all,

 

For a database on medicinal plants i would like to combine fields from different records based on the condition that the records refer to the species.

To illustrate my question I include a screenshot showing a small portion of one of the 30 tables in my database:

Screen Shot 2016-08-26 at 4.02.09 PM.png

What I am hoping to do, is reduce the number of records and effectively create unique identifyers in the "Scientific Name" field.

Therefore, I need a function, which allows me to combine the distinct entries in the "Use category" field, whenever the records refer to the same "Scientific name". That is, rather than having 3 records for "Scientific name = Abelmoschus moschatus Medik" I would like a single record which in the "Use category" field reads "A1, D1, S1"

 

Any help would be greatly appreciated.

Outcomes