I am struggling a lot with the problem that I will explain below. I am in need of a solution as I couldn’t solve it by myself.
I am making software for car rental, and I need the following:
I have a thing called CAR which contains all the info regarding cars and conaint a list of fields CAR UNIT.
CAR UNIT contains a list of BOOKINGS.
What I need is a display of available CARS. It needs to check each CAR, CAR Unit, and Each booking. And if no current CAR has a CAR unit that does not have any booking that overlaps with the current booking date, it needs to display that car.
Please let me know if someone can help me.