Hi folks, I’m hoping someone can take pity on me because I’m struggling to get my head round this as I’m an old school spreadsheet geek! Airtable would be ideal for how we want to work and would stream line things rather than the excel documents we use just now, but I’m lost without a vlookup
I have a “master” table with 5000ish records, each with 25 fields. The Primary field is an account number.
I have lots of other tables, each one is a particular clients own table. These contain between 100-200 records, with the same account numbers as from the master table as the primary field, and some notes against each account number. They might add or delete Account numbers from their own table, but they will always be contained in the master table.
Is there a way to look up the primary field in the clients table and pull the 25 fields from the master tables corresponding primary field through automatically without having to manually select it through the lookup function each time? I would use a vlookup here if it was a spreadsheet.
Or do I simply need a master table, the clients own table, and then cross reference the fields on a third to get the desired effect?
I think I need more experience with relational databases…
many thanks in advance!