I am trying to find the best way to program a timeshare inventory. Here is the problem, one unit has the possibility of being sold annually, odd or even years. If the unit is sold for just even or odd, I then need the open inventory to reflect the opposite year that is available. If the unit is sold annually I need it to be removed from open inventory totally. Also, If the unit is returned I need it to show-up back in open inventory.
Does anyone have any ideas of how to make this work simply?