How can I track inventory in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a modified version of the Issues database on the MS templates site.
Basically I have added a table called laptops. I use the data base to track
laptops that are on loan. Everything works exactly as I want, but I am trying
to retrieve records of laptops that are available. Currently I have a field
caled status, which shows out/active returned/closed. This is not ideal as
nothing prevents the laptops numbered 1-50 from being assigned to more than
one user. So essentially in my form when the new loan record is being
created, i want the loan laptop drop down list to only provide laptop numbers
that are not currently active/open. I am happy to provide a copy of the
database for sake of review/clarification
 
Our your out/active returned/cloase fields check boxes?

If so have your drop down list controlled by a query which filters out
the laptops that are on loan.
 
Back
Top