Linking two tables / bug?
I am having trouble linking two tables. In the first table I have a primary field called “company”. A second field here is “email”. Each “company” has several “emails”. In the 2nd table, I have a primary field with “company”. Another field is “files”. Each investor has several “files” linked to it. I am copying investors in a separate column that I am then linking to the first table. The problem is that the link only works for the first instance that “company” shows up in the 2nd table. Is this a bug? Any work-arounds?
Sorry, not entirely sure I understand what you’re trying to do, but a couple of thoughts occur to me.
First, remember that in Airtable you are always linking to primary columns (primary fields). You don’t pick which part of another table you link to: You link to the primary column, always.
But you can also pull data from other columns. Let’s say you’re linking records in TEACHERS table to records in STUDENTS table. Teacher Smith is linked to students Tom, Dick and Jane and Joaquim. In the record for Smith in TEACHERS, you’ll create a field that links a teacher record to one or more records in STUDENTS. That field will show the names of all the students the teacher is linked to. But now, say you also want to see their phone numbers, or their dates of birth. You could go about this a couple of different ways.
- If the student’s date of birth is important to that student’s unique identify — say, as a way to distinguish one Jane from another — you might make the primary column in STUDENTS a formula field that concatenates name and DOB.
- Alternatively, you’d probably use a Lookup or a Rollup field. Lookups are fairly easy, but Rollups can be slightly more complex and you might want to read up on that topic.
Must say that several things about your screenshots make me nervous. I’m afraid you’re not going to get where you’re going, given the way you’re starting. But I could be wrong. As I said I don’t really understand your data-modeling problem. Good luck.
William
