On our table we have one for our units that can be rented out by someone for a time frame. However if someone is moving out on the 22nd for example, we can book another person to move in after that date. However if I look at the table for the units, ...
We are using Airtable as a Storage Company.
This means that we have a set number of units with different information and another customer table too. If a customer is in unit 1 then we will show that relationship. However when a customer moves out the...
That is perfect, thank you for the help! Does exactly the job, need to get my head around creating fields in other tables to affect another one. Brilliant thank you.
The only issue then is that the links that they have to the units will remain.
So if they move out of unit 1 and I mark them as archived, the archived customer will still show in the units table as a link
