I’m hoping to use AirTable to help plan and organize a trip to Italy, visiting a few cities. As I currently have it set up, I have tables for “Logistics” (flights, car rental, hotels…etc.), “Activities” (sights, tours…etc.), and “Food/Beverage.” I also have one “Master Itinerary” tab where I’m trying to link records from each of those tables.
In an ideal world, I’d like to create some views on the “Master Itinerary” tab, where I can view items by, for example, “Cities” (where it would show me my flight, my accommodation, and restaurants I’d like to go to), and a “To-Do” list for things that I need to book, regardless of City,
However, each of these tables has a column called “City” with a single select, and when I bring it into the Master Itinerary, I can’t group by a SINGLE city column, because I see “City from Logistics” or “City from Activities.”
Does anyone have experience with creating something similar, or have ideas for how I can make this more cohesive? I feel like I’m missing a step here about how to connect these tables in the right way.
Thanks in advance for your help - Airtable newb here!
Edit: Since we don’t have any hard-and-fast “dates” where we’ll be doing things, and just want to see what’s available every day, I didn’t think a “date” field would work (hence the "non-daily-specific itinerary in the title), but I’m open to it!