Update table 1 when a matching record shows up in table 2

[brianfidler]

I have two tables; my primary table is a listing of our inventory units that we are running promotions for; when an inventory item sells, we add it's stock number to table 2. I'm looking for a way to set the status of each record in table 1 so that it shows as "for sale" if its stock number doesn't exist in table 2, and gets updated to "sold" when its stock number is added to table 2 as sold. 

Any ideas on how to best achieve this?

[TheTimeSavingCo]

Is the primary field in Table 1 the stock number?  If so, you can try:
1. In Table 1, create a linked field to Table 2
2. Create an automation that will trigger whenever a record in Table 2 has a stock number and its linked field to Table 1 is empty. It will have an "Update Record" action that will paste the stock number into the linked field
  - This will automatically link the record in Table 1 with the same stock number
3. In Table 1, create a formula field that will display "For sale" if the linked field from step 1 is empty, and "Sold" if it's not empty

[ScottWorld]

@brianfidler 

You probably want to put all of your items into one table, and just use different “views” to toggle between seeing different sets of items.

If you’ve never used views before, I discuss views at length in my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/