Hire Availability

[owaring]

Hello all,

I'm building a new system to look after a hire inventory.

I'd like to ask the room how they would approach this as a solution.

I will have a "jobs" table which will relate to an "equipment" table. There should also be an "inventory" table detailing what items are offered for hire and how many are available for hire.

I'd want to compare what jobs occur simultaneously and return a how many are left free for hire.

Returning qty available for a specific date would be ideal also.

Many thanks in advance.