wtheus1953@hotmail.com (Waldot) wrote in message news:<87b4ee55.0402041417.27a7923f@posting.google. com>...[color=blue]
> We are trying to implement a video library at work for a series of
> training videos. Our employees will contact us by email requesting a
> videotape which we will ship out by Fedex for a period of 30 days. We
> already have properly linked tables with all employees, offices, etc.,
> so that part of the job is done.
>
> What I need help with is the check-out check-in functionality.
> Ideally, I would like to be able to track the number of copies of tape
> in stock and to put people on a waiting list for tapes that are out of
> stock.
>
> I'm sure that plenty of people have done this in the past. I even saw
> a reference to an old Access 97 template, but I can't seem to find it.
> Any ideas or examples would be greatly appreciated.[/color]
There's an example in Access 2000 Power Programming, by Scott Barker
(SAMS publishes it, I think.) Check in/out... I would create loan
records for each time a person borrows a tape.
(BorrowerID, TapeID, ShipDate, ReturnDate)
TapeID - each tape has a unique identifier. Autonumber is fine - it
just has to refer to ONE copy of a tape. You should probably read
Albert Kallal's notes on reservation systems, because that's what this
sounds like.
