Importing tables and usable links

My data consists of 4 tables, each table having a unique ID that is a number. Those numbers are the links between the tables. When I bring it into AirTable, everything is linked properly, but the linked field being a number isn’t of any use when a user tries a search, They need to be able to enter something other than the number of the record to find what they are looking for. If they are looking for something in the linked table with a column of City, they need to be able to search by the city instead of guessing at numbers until they stumble across the right one.

A workaround is to use a concatenated field starting with the number then throwing stuff into it that would be useful for searching. I a working on converting it to use just such an approach but there are a lot of multi-instance fields that are a royal pain to convert. There has to be a better way. I know there is something obvious that I am missing.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.