A
Access Greenhorn
A user puts together a package of reagents. They use a form to input what
reagents went into the package and to whom the package is sent; the "to
whom" info is on the main form based on one table, "what reagents" info is on
a datasheet view subform based on another table, tables are linked by package
ID no.
Each reagent is assigned a batchcode (PK) when made, and information unique
to that batch is recorded. Different types of reagents have different
information stored about them. (Example, you would record a volume a liquid
and a size for a solid)
Some of these reagents need to have sent with them Certificates of Analysis
(C of A) which contain mostly generic info that doesn't change (storage,
hazards, warnings etc) and the above mentioned information unique to that
batch and reagent type.
If more than one of the same type of reagent, or more than one batch is sent
in the same package, each reagent and/or batch and its info, can appear on
one C of A report (since the generic info is the same for all). (Example: 1)
Yellow liquid, batch 1, do not use above 30°C 2) Yellow liquid, batch 2,
do not use above 40°C 3) Red liquid, batch 1, do not use about 0°C)
What is the best way to go about creating a filtered C of A report, filtered
on the reagents chosen to go into that package? And how do I create a
command button to automatically open this filtered report?
Please keep in mind I would like to be able to open the C of As for
completely different reagents (i.e. diff reports), since one package may
contain entirely different reagents. (I envision a diff command button for
the diff C of As would be needed)
I don't want to waste anyone's time so feel free to answer without code at
this point; what you suggest may not be feasible for my situation. I cannot
make the database too code rich since I may not be around to maintain it.
Thanks all,
Access Greenhorn
reagents went into the package and to whom the package is sent; the "to
whom" info is on the main form based on one table, "what reagents" info is on
a datasheet view subform based on another table, tables are linked by package
ID no.
Each reagent is assigned a batchcode (PK) when made, and information unique
to that batch is recorded. Different types of reagents have different
information stored about them. (Example, you would record a volume a liquid
and a size for a solid)
Some of these reagents need to have sent with them Certificates of Analysis
(C of A) which contain mostly generic info that doesn't change (storage,
hazards, warnings etc) and the above mentioned information unique to that
batch and reagent type.
If more than one of the same type of reagent, or more than one batch is sent
in the same package, each reagent and/or batch and its info, can appear on
one C of A report (since the generic info is the same for all). (Example: 1)
Yellow liquid, batch 1, do not use above 30°C 2) Yellow liquid, batch 2,
do not use above 40°C 3) Red liquid, batch 1, do not use about 0°C)
What is the best way to go about creating a filtered C of A report, filtered
on the reagents chosen to go into that package? And how do I create a
command button to automatically open this filtered report?
Please keep in mind I would like to be able to open the C of As for
completely different reagents (i.e. diff reports), since one package may
contain entirely different reagents. (I envision a diff command button for
the diff C of As would be needed)
I don't want to waste anyone's time so feel free to answer without code at
this point; what you suggest may not be feasible for my situation. I cannot
make the database too code rich since I may not be around to maintain it.
Thanks all,
Access Greenhorn