I am building a new reporting database for a small laboratory I own. The one I built and used before crapped and I thought, but did not have it Carbonited. Anyhow, I am building a new one with these relational tables many to one.
[Customer] - many reports
[Report] - may have one to many samples
[Sample] - may have one to many analysis
[Analysis] - hundreds of analytes to choose from
various other look-tables
I have a sample log-in form that the office help inputs the information supplied by the customer one Report at a time. It has a sub form to enter the one -> many samples for each Report.
This is what I am looking for a way to do: Since each Sample can have one -> many Analysis, I don't want the office help to have to choose each of those Analysis items on at a time. Especially since most of the Analysis have some sort of routine grouping. (i.e. Test Package 1 = Analysis1+Analysis2+Analyis5; Test Package 2=Analysis2 through Analysis7; Test Package3 = Just Analyis4; and so on) I am looking for a way for my office help while entering new information on each Sample in the sub-form to choose a Test Package that appends the various Analysis for a Sample from a Test Package table.