Q&A
trying to set up a proper relational structure. i have:
- customers table (name, email, company)
- orders table (customer, product, amount, date)
- products table (name, price, category)
in airtable i would just link the customer field in orders to the customers table. how do i do this here? specifically:
- can a field in one table reference a row in another table?
- when i view an order can i see the customer details without a separate lookup?
- if i update a customer name does it reflect everywhere?
yes you can set up linked records. when creating a column choose the "link" type and select the target table. once linked:
- clicking a linked cell shows the related record details
- you can create lookup columns that pull specific fields from the linked table
- updates to the source record reflect everywhere its linked
its similar to airtable relationships. the UI is slightly different but the concept is the same
exactly what i needed. the lookup columns are key for displaying related data without duplicating it
one tip: plan your table structure before building. changing relationships after you have data is possible but annoying. think about which table "owns" the relationship (orders belong to customers, not the other way around)
Community