I am in the process of making a solution for my tuxedo business. Which rents tuxedos. I am looking to make a Inventory solution that once an item is reserved for a certain date it is taken out of stock and still allows me to reserve for other weekends but also goes and finds/filters out to the right size and we can have many.
Attached is a snap shop of my relation ships so far. I am getting stuck right now in how to implement it.