A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Chain of Custody Generation?



 
 
Thread Tools Display Modes
  #1  
Old May 1st, 2008, 06:47 AM posted to microsoft.public.access.forms
jessi
external usenet poster
 
Posts: 23
Default 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  
Old May 1st, 2008, 03:44 PM posted to microsoft.public.access.forms
jessi
external usenet poster
 
Posts: 23
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.