VB Programming - Inventory Program

[cwickam]

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?

[Comatose]

Simply? Well, no. Is this being done with VB6 or .NET? Is This using Flat (text) files or database systems (ado, sql?). Is there a deadline right now?

[cwickam]

I am actually writing this in VBA using an Access Database. My deadline to have the entire database done by the end of May.