Hi
I'm new to access so bear with me...
I have made a database where i register submissions to a laboratory. The registration form assigns a number (ID) to each submission and you enter the number of samples that were included in this submission. From these two fields i need to generate a list.
So to give an example of what i want to do:
A submission is ID'ed S0001, S0002 and so forth. In the first submission (S0001) i have 3 samples. in S0002 i have 2 samples. For each submission i need to generate a "list" (is this even an entity in access?) of the samples named:
S0001-1
S0001-2
S0001-3
And for the second submission:
S0002-1
S0002-2
How can I make access generate these lists automatically?
When the list have been generated, I will need to be able to print them on individual labels.
Please, can anyone help me with this?
Best wishes
Jesper