linked records between tables - how to set up proper relationships

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?