I have two databases that are related to each other by an ID number. One is a list of videos and the other is a checkout database. Everything works fine for checking videos in and out. My next task however is to create a history of the videos checked out by faculty. Currently when a video is check back in, the title is removed from the list of videos that the faculty have out. I have tried using the Lookup option which I thought would work but it also removes from the list any videos that have been returned.

My ultimate goal is to have a list of all videos that any particular faculty has taken out and possibly a list of how frequently a video is used.

Thanks

Sherry

Why not build a history file of checkouts? When they complete a transaction - ie when they check the video back in - then whatever button is pushed to check the video in, should also create a record in a seperate database, with video title, faculty member, out date, and in date.

Hi,

My ultimate goal is to have a list of all videos that any particular faculty has taken out and possibly a list of how frequently a video is used.

To do this, you need a table recording the 'use' of each video. Every time a video is used, the system creates a new record of 'usage' and enters the Video ID, and the User ID (from their separate tables). The 'usage' record should probably also have a dat of when it was checked out, and then again (when returned) when it was checked back in.

You could then hook the usage table to the Video table, and the User (faculty) table, and through the relationships see who used what when, and (perhaps more importantly) who's using what now.

HTH