Reservation system & inventory ???

[Whit Porter]

Hi -

I'm tryng to figure out how to relate an inventory system to a reservation system. The inventory part I have - but how to be able to create a "reservation" - for a specific period of time - for a specific piece of inventory - is what is giving me fits.

Any sugestions as to which direction to turn would be HUGELY appreciated.

Thanks!

[Stuart Taylor]

Why not post a file - at the moment it looks like all you need is a field called "reserved" and format it with a "checkbox" + "valuelist" with the simple data "reserved" in it.

[comment]

See if this thread can get you started.

[Whit Porter]

Sorry - I didn't explain this very well.

Say I have ten of a certain kind of chair in my inventory.

They will be rented at various times, in various quantities in the future, and then returned to inventory.

And then, of course, I have a warehouse full of all different kinds of furniture.

I have got the inventory part, creating and adding multiples of the same item.

I can relieve inventory (shipping) and return to inventory.

But the part that has me stumped is creating a DB I can query that tells me whether that item will be available on any given day in the future. It seems there would have to be a record for every piece (Y) - and then a reservation record (X) (with a field saying yes or no available for that day) for every day in the future for each Y record. So that, for example, if I wanted to track two years ahead, there would have to be 730 (2X365) X records for each piece (Y) of inventory. And if I had 10 of those Y items, that would mean 73,000 records. Yikes! There must be another way.

Makes my head hurt !

[comment]

How is this different from the problem discussed in the thread I have linked to?