Importing one-to-many relationship

[Elizabeth_Crisf]

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.

Elizabeth

[JonathanBowen]

Hi @Elizabeth_Crisfield - it sounds like you’re doing the right thing - can you share some screenshots so we can see some more detail?

When I mock-up your scenario it works as you describe. I have a Species table:

And a Habitats table that I import data into:

Back in my Species table, I see all of the Habitats for a species:

JB

[Elizabeth_Crisf]

Thank you for showing me that simple mock-up. I worked through your simple example and it showed me that my problem was that my main table didn’t use the species code in the key. The species code was in the table, but not in the first field. When I fixed that, everything linked up. Problem solved!

[Matt_Lightbourn]

Hi, I know this was apparently solved before but I still don’t get it. I have a table where a put a key which has many rows in the linked table but it only shows me the first result.

Here’s the table I want to display results, not only one result

Here’s the table I want all related rows to be displayed in my lookup results, not just the first one

I also would like to include a condition because, in this reference data set, I have different sets of transaltions for construction_walls, so in this link, I only want to relate on the IDs where type is “Purple to BAPI”.

Thanks in advance

[JonathanBowen]

Hi @Matt_Lightbourn - I don’t really understand your table structure here. Can you add screenshots of both tables, ideally without any grouping?