I have a table of species, 1 per row.
I have another table (.csv to import) where species are linked to habitats. Each row is a unique habitat, and several rows may be linked to the same species.
I want to pull the habitat types into the original species table, where one field captures the many habitat types linked to the species.
using linked fields and rollup or lookup I can not get it to show me all the values of habitat that may be associated with a species. It just shows me the first one it comes across. I chose linked to many when I linked it.
I searched the archives but couldn’t find the answer to this question (though I’m sure it’s here somewhere) - apologies - I link to the answer would be very welcome rather than rewriting it.