#Airtable vs access how to

→ For now, think about your workflow and map out which information you want to connect together.

#Airtable vs access how to

In the next step, we’ll talk about how to create these connections in your Airtable base. But keeping your lists in separate tables doesn’t mean they have to live in isolation-and they shouldn’t! Our projects have related action items, events have attendees, and so on. In Airtable, it’s a best practice to capture each of these lists in a separate table, where you can store each item and all of its details.

Or maybe you have a list of events, a list of attendees, and a list of venues. You might have a list of projects, a list of action items, and a list of clients. What information you’re tracking, and how it connects together, is completely dependent on your workflow. Keep your information clean and reduce duplicate data entryīefore you start building relationships between your records, you’ll want to make sure you know what those relationships should look like.Create the right structure to connect and easily reference related information.Define the relationships between information that matters for your workflow.In this guide, you’ll learn how to link records in Airtable today! In Airtable, not only can you store every piece of key information in a record, but you can also easily link those records together to capture the dynamic relationships between them. Knowing which project connects to which client, or which venue you’re using for which event, is crucial to staying on task-and keeping all those relationships straight can get messy fast! Introduction Plan availability When you’re managing a workflow, there’s a lot of information to keep track of.