I’m fairly new to Airtable, so I’m not sure I’m using the right terminology, but I have one database with (currently) 6 different tables, each with linked records between them. To put my question simply: I’ve got a column in Table A that is records in Table B, and then in Table C I want to be able to have a column for each of Table A and Table B, and since those two already have a “relationship” I want the column for Table B to auto-populate when I select what’s in the column for Table A. Otherwise, I’m manually selecting it redundantly and increasing the risk of error every time I do so.
Any help (whether answers, or the right terminology to refer to what I’m looking for) would be much appreciated!