Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / September 2005

Tip: Looking for answers? Try searching our database.

Inventory Issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mierow - 20 Sep 2005 19:25 GMT
We have laptops that get checked out to students and staff, and we would like
to do the following but don't know how:

1) Allow students to check out a laptop
2) Allow staff members to check out multiple laptops

We are working with no budget for this and are using an old access database.
We thought we'd try to create a new one with some of the features that we'd
like to see.  Any tips or suggestions would be greatly appreciated.  Thanks
in advance.
Ed Warren - 20 Sep 2005 21:37 GMT
You apparently have the following

People
Some People are students
Some Poeple are Staff Members

Are any People both students and staff? If so what rule do you you follow,
staff (many laptops) or student (one laptop)

a. You can set up a table of people with a field to check if student or
staff (or both)
b. Setup two tables of people (students, staff)

Laptops
Each laptop can be issued to one and only one person at a time (1:1)

Some people can have many laptops checked out at one time (1:M), but some
people can have none or at most one laptop at a time. (1:1)

So what you are wanting is a 1:1 relationship sometimes and a 1:M
relationship sometimes.

You can
a. establish two tables for the relationships and set one up as
Student-Laptop 1:1 and the other as Staff-Laptop 1:M or
b. establish the rule in code to limit people that are students to only one
laptop (when entering the data check to see if they are a student and if so
if they already have a laptop checked out.

Your decisons in this area should be guided by good database design (table
normalization) and the business process you use -- e.g. do you want the user
to go to one form to check out the laptops to both students and staff, or
are these separate business processes.  e.g. students one place, staff
another.

Your old database might lead you to what the developer was thinking in these
areas.

Ed Warren.

> We have laptops that get checked out to students and staff, and we would
> like
[quoted text clipped - 10 lines]
> Thanks
> in advance.
John Marshall, MVP - 20 Sep 2005 23:50 GMT
Add a field to the laptop table indicating who has it signed out. Before a
student can sign out a laptop run a query against this field to find out how
many laptops this student has signed out. If none; then proceeed.

John...    Visio MVP
Mierow - 21 Sep 2005 15:16 GMT
Thanks guys.  Both of you have given us some great advice and things to look
at.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.