Sniper-BoOyA-
Registered User.
- Local time
- Yesterday, 16:53
- Joined
- Jun 15, 2010
- Messages
- 204
Goof Afternoon,
I am working on a database for our laboratory and ive come across the following;
The database i have been working on is for our concrete lab.
They make prism's and they perform a couple of tests on those prisms. (Flexural strenght and Compressive Strength).
Basically they get the a sample from the client. They name the sample with a sampleID. They use the sample to make the prisms (6 total).
3 prisms to be tested after 28 days, and 3 prisms to be tested after 91 days.
Ive split both in to 2 tables.
Both tables contain the following fields;
id - Autonumbering
labnr - Text (translation: SampleID)
DateofTest - Date/Time
LengthPrism - Num
DPrism - Num
....
id_____labnr ...
1____13-001
2____13-001
3____13-001
4____13-002
5____13-002
6____13-002
Now heres my question;
Is it possible to add another field, and add some sort of autonumbering loop which allows you to number the prisms inidividually as long as the labnr is the same?
I.e. ; Each Labnumber will have 3 prisms and i am looking to do the following;
id_____labnr____AUTONUMBERLOOP
1____13-001________1
2____13-001________2
3____13-001________3
4____13-002________1
5____13-002________2
6____13-002________3
My question; Is this possible, if yes how would you do this?
Ive tried a lot of things like adding a autonumbering field to the table and somehow control the autonumbering mechanic, but no luck so far.
If you guys have any ideas/thoughts, i am looking forward to hear those.
Cheers,
Michael Schrijver.
I am working on a database for our laboratory and ive come across the following;
The database i have been working on is for our concrete lab.
They make prism's and they perform a couple of tests on those prisms. (Flexural strenght and Compressive Strength).
Basically they get the a sample from the client. They name the sample with a sampleID. They use the sample to make the prisms (6 total).
3 prisms to be tested after 28 days, and 3 prisms to be tested after 91 days.
Ive split both in to 2 tables.
Both tables contain the following fields;
id - Autonumbering
labnr - Text (translation: SampleID)
DateofTest - Date/Time
LengthPrism - Num
DPrism - Num
....
id_____labnr ...
1____13-001
2____13-001
3____13-001
4____13-002
5____13-002
6____13-002
Now heres my question;
Is it possible to add another field, and add some sort of autonumbering loop which allows you to number the prisms inidividually as long as the labnr is the same?
I.e. ; Each Labnumber will have 3 prisms and i am looking to do the following;
id_____labnr____AUTONUMBERLOOP
1____13-001________1
2____13-001________2
3____13-001________3
4____13-002________1
5____13-002________2
6____13-002________3
My question; Is this possible, if yes how would you do this?
Ive tried a lot of things like adding a autonumbering field to the table and somehow control the autonumbering mechanic, but no luck so far.
If you guys have any ideas/thoughts, i am looking forward to hear those.
Cheers,
Michael Schrijver.