I am trying to populate my database with historical data I have stored in spreadsheets about plant species collection locations and other ecological data. We use a 6 letter code (unique) as a shorthand for each species we work with for example ACHLEM = Achnaterum lemonii (a grass). I have created a table that lists every species we work with and its associated 6-letter code along with some other general info about the species. I want to import new data into another table and somehow have baserow read and recognize those codes in the new data. I want to do this because my historical data tends to have species spelling errors but the 6-letter codes are pretty reliable.
When I bring in my historical data I use the species code as the key (leftmost column). How do I get baserow to recognise that ACHLEM in my historical data matches the other data I have already built in for my species list?