How do I create a database that checks out files?

  • Thread starter Thread starter Emily
  • Start date Start date
E

Emily

Hello,
I have a database that includes 4 tables that contain
different types of files. I want users to be able to
access the form for the file that they are looking for
and 'check the file out' from the database. Therefore the
form would show that the file is checked and when and who
checked it out. Can access do something like this?

Thanks for your time,
Emily
 
Hello,
I have a database that includes 4 tables that contain
different types of files. I want users to be able to
access the form for the file that they are looking for
and 'check the file out' from the database. Therefore the
form would show that the file is checked and when and who
checked it out. Can access do something like this?

Thanks for your time,
Emily
Click to expand...

You'll need (at least) three tables for this: the table of Files (I'd
*strongly* suggest having a single table of Files; if the four
different types of files are in four similarly-structured tables,
consider merging them into one table with an additional file-type
field) would be the first.

Next would be a People table listing the users who may be checking out
files. This table would have a unique PersonID (names are NOT unique
and should not be used as a key).

The third table would be the Checkout table: it would have a field
linking to the Files table's unique id field; another field linked to
the PersonID; and fields for date checked out, date checked in, and
any other information needed about the "checking-out" operation.


John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top