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?

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?

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.