B
Brigitte P
I need a database that keeps track of equipment (wheelchairs, walkers, etc),
who has the equipment, and whether the equipment is available or not. This
seemed simple, but it doesn't work like I anticipated.
I have table 1 for equipment (one unique number per piece equipment), tbl 2
patients, and tbl 3 for checkout which has a related field to equipment, one
to patients, and date checked out, and date checked in. The problem is the
availability of equipment.
When I enter checkout/checkin, I have a simple expression: Available:
IIf([DateAssigned]=0 Or [DateReturned]<>0,"Yes","No") which works fine. But
how do I then get the next record (it's in datasheet view) to only show the
equipment that is available? It seems that I can't requery on the source
query for the data entry form.
Do I need to put the available field in the equipment table and update it
via an update query when the checkout/checkin conditions are met? I tried it
but it didn't work very well, and I'm afraid that the users may not manually
update the available field anyway (which would make it easy). I need to
somehow automate that field.
I'm stumped; is there a solution database out there that I could lean on?
As always, many thanks for your help.
Brigitte P.
who has the equipment, and whether the equipment is available or not. This
seemed simple, but it doesn't work like I anticipated.
I have table 1 for equipment (one unique number per piece equipment), tbl 2
patients, and tbl 3 for checkout which has a related field to equipment, one
to patients, and date checked out, and date checked in. The problem is the
availability of equipment.
When I enter checkout/checkin, I have a simple expression: Available:
IIf([DateAssigned]=0 Or [DateReturned]<>0,"Yes","No") which works fine. But
how do I then get the next record (it's in datasheet view) to only show the
equipment that is available? It seems that I can't requery on the source
query for the data entry form.
Do I need to put the available field in the equipment table and update it
via an update query when the checkout/checkin conditions are met? I tried it
but it didn't work very well, and I'm afraid that the users may not manually
update the available field anyway (which would make it easy). I need to
somehow automate that field.
I'm stumped; is there a solution database out there that I could lean on?
As always, many thanks for your help.
Brigitte P.