View data in table 1 in table 2

[Sniper-BoOyA-]

Good Afternoon,

Ive got a (small) question regarding a table with a Primary Key.

Ive got a table named : tblProctor

In that table i have several data, but the most important are ProctorID and Samplenr.

A form will be used to enter data into this table. The user gets a list of the samples that were added to the database , in my case 10.

The user gets to make a selection of samples he / she wants to use for her Proctor test. Once she ticks the selectionbox, it will higher the ProctorID by 1. (IF box=True Then ProctorID+1). To test this ive made a txtbox, made the source ProctorID, and locked it so the user cant change the value of the txtbox.

It works great.

But now i want to give the user the opportunity to link more samples to the proctorIDs that have been made.

So lets say, ive got 10 samples.

I select both sample 1 and sample 8 for the proctor test. This results in the ProctorID being 1 for sample 1, and ProctorID being 2 for sample 8.

It is possible that 2 or 3 samples will have the same properties, and have the excact same content. In that case, it will be pretty useless to have to do the test all over again etc.. Therefore i would like to be able to say, ok originally ProctorID 1 was 'linked' to sample 1, but sample 4, 7 and 10 are the same, so i would like to link them to proctorID 1 aswell.

To do this, i thought making another table would be the best solution. Made a new table, with ProctorID and SampleNr

ProctorID will be looking up ProctorID in tblProctor
Samplenr will be looking up Samplenr in tbllabgegevens (Lab dataentry where the samples are stored)

It works, i can now select multiple samples and i can select the proctorIDs that have been made earlier. But i was wondering if it was possible to also show the ProctorIDs and Samplenrs used in tblProctor. To prevent duplicate entries.

Or do you suggest something different. Im open for suggestions regarding this issues, im all ears!

Thanks in advance!