Here is what I am trying to do.
I have 1 base that is every customer and their submissions. They can be split up into different order numbers. So every row in Base 1 has an order number attached to it.
The next base is order numbers and shows all order numbers and what stage they are in.
I want the “stage” column in sheet 1 to update what stage the order number is in whenever I change “stage” in the order numbers sheet and update it is for all records that are in that order number.
So I change “stage” in “order number base” and then every row in Base 1 that has that same order number will change the “stage” filed to match up.
I am assuming their is a way to do this but I am running into a wall - Yes, I am new to airtable but I see the massive potential!