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, I can see multiple customers attached. Is there a way to filter that so only the customer which is currently meant to be in there shows up.
For example, if we have two customers ZRO100 and DRO101 have booked unit 1. ZRO100 is moving out on the 20th of April and DRO101 is moving in on the 21st of April, how can I display only ZRO100 until the 20th and DRO101 after.
I would like this in reverse too, so that we can see that someone is going to be moving into the unit afterwards.
I have been trying to sort it out for ages but I think I need an opinion from someone with more experience.