I would like to withdraw this post. I figured out an easier way to approach
the problem.

Jessi

"Jessi" wrote:

Hello,

I'm trying to set up the tables, forms, and reports required to generate
chains of custody for samples collected in the field. So far I have the
following tables:

tblCOC
RecordID (pk)
SampleID
SampleType
ContainerType
NoContainers
DatePacked
TimePacked

tblAnalysesReqd
Id (pk)
RecordID (fk)
AnalysesReqd

Each sample will be entered multilple times in tblCOC throughout the course
of the project (which is why the SampleID is not the primary key). Each
sample will need to be analyzed for multiple contaminants. So there will be
one record in tblCOC to many records in tblAnalysesReqd. Some example
records would be:

tblCOC
RecordID (pk) = 1
SampleID = BD-0WW58-X-0001
SampleType = Rock
ContainerType = glass
NoContainers = 3
DatePacked = 4/30/08
TimePacked = 15:30

tblAnalysesReqd
Id (pk) = 1
RecordID (fk) = 1
AnalysesReqd = VOC

tblAnalysesReqd
Id (pk) = 2
RecordID (fk) = 1
AnalysesReqd = Tritium

tblAnalysesReqd
Id (pk) = 3
RecordID (fk) = 1
AnalysesReqd = Deuterium

I can set up a form (frmCOC) to input the data stored in tblCOC, but I would
like there to be a link of some kind to the form (frmAnalysesReqd) to input
the data for the tblAnalysesReqd. I would like to pass the RecordID from the
frmCOC to the frmAnalysesReqd when its opened. I think I could figure this
part out. What I'm having difficulty with is a way for the user to choose
multiple analyses for each RecordID which would be stored as separate records
in the tblAnalysesReqd.

I envision something like:

RecordID = 1

VOC X
Tritium X
Deuterium
Inorganics X

In this case RecordID = 1 would appear in tblAnalysesReqd 3 times (once for
analyses VOC, once for Tritium, and once for Inorganics).

I'm not certain if this question makes any sense at all. Please let me know
if I can clarify in anyway because I'm really stumped.

Regards,

Jessi