Sniper-BoOyA-
Registered User.
- Local time
- Today, 08:46
- Joined
- Jun 15, 2010
- Messages
- 204
Good Afternoon,
I am currently working on a Access Application to determine the degree of compaction of sand.
The degree of compaction is determined and calculated by putting samples in a Proctor machine.
At this point, the user is able to select the different samples that need to go through the Proctor machine. (on a form)
They simply select the samples by ticking the selection boxes, and in the same table as those boxes theres a ProctorID which has a autonumbering property.
Every tick = ProctorID+1
For example :
I have a total of 10 samples. And i want to use sample 1 and 8.
Sample 1 = ProctorID 1
Sample 8 = ProctorID 2
So far so good.
I gave the user the opportunity to make graphs, etc..
But here's the thing,
Sometimes the employees in the lab have to mix 2,3 samples. Which means a proctor can be made of 2 to 3 samples. Instead of 1.
I was wondering if its possible to select more samples per Proctor, with the ProctorID still intact?
My first thought was, that is not possible, due to the autonumbering. But before i redo the entire thing (2 months of work) i wanted to ask you guys for any suggestions or ideas first before i throw 2 months of work in the trash.
Thanks in advance!
I am currently working on a Access Application to determine the degree of compaction of sand.
The degree of compaction is determined and calculated by putting samples in a Proctor machine.
At this point, the user is able to select the different samples that need to go through the Proctor machine. (on a form)
They simply select the samples by ticking the selection boxes, and in the same table as those boxes theres a ProctorID which has a autonumbering property.
Every tick = ProctorID+1
For example :
I have a total of 10 samples. And i want to use sample 1 and 8.
Sample 1 = ProctorID 1
Sample 8 = ProctorID 2
So far so good.
I gave the user the opportunity to make graphs, etc..
But here's the thing,
Sometimes the employees in the lab have to mix 2,3 samples. Which means a proctor can be made of 2 to 3 samples. Instead of 1.
I was wondering if its possible to select more samples per Proctor, with the ProctorID still intact?
My first thought was, that is not possible, due to the autonumbering. But before i redo the entire thing (2 months of work) i wanted to ask you guys for any suggestions or ideas first before i throw 2 months of work in the trash.
Thanks in advance!