If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chain of Custody Generation?
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 |
#2
|
|||
|
|||
Chain of Custody Generation?
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 |
Thread Tools | |
Display Modes | |
|
|