Predefined sets

[sglavanovi]

Hello!
I have created access database for laboratory sample evidence and now I would like to use it to collect analysis results. The information about sample is stored in one table (sampleid, samplename, date, ....)

One of the possibilities is to create another table, only for the results, and create one-to-many relationship between the tables (one sample can be analyzed for more different parameters) but for each sample multiple parameters should be entered manually or from drop down-list. However, I would like to create predefined sets of parameters and used them for the specific samples. For example, for the sample 1 I’ll use set 4, for the sample 2 set 1, for the sample 4 set 1, ...

Do you have any ideas how can I do this?
Thanks!

S.

 

[MarkK]

Yeah, so you need a few tables, like...

tParameterSet
'represents a single parameter set
ParameterSetID
ParameterSetName
DateCreated
...

tParameter
'represents a single member of a parameter set
ParameterID
ParameterSetID
ParameterName
...
...

tSample
SampleID
SampleDate
SampleName
...

...and so now for each sample you can associate it with mutiple parameter sets if you use a table like....

tSampleParameterSet
SampleParameterSetID
SampleID
ParameterSetID

Does that make sense?
Cheers,
Mark

 

[wiklendt]

i have that kind of setup in one of my lab databases too - i use an append query behind a form command button (in combination with a set combo) to automatically add the set to my run so that the user can simply add the results, rather than knowing which tests are in the set as well.

 

[sglavanovi]

Thanks a lot!
I succeeded to create the sets and use them, now need to create copy button to automatically add the sets to my samples and collect the results. I'll let you know if i succeed or fail



Cheers!

Sinisa