Forum Discussion
JasonJohnson
6 years agoQrew Assistant Captain
I am going to go I think simpler on this but let's see if I get the basics.
1 main sample to be combined with another of 4 samples. The 4 samples are limited so they can only be used once and I assume the main sample is a quantity of 4 since you want to combine it with 4 other samples (separately of course).
I would make a text formula to combine the sample names [Main Sample]&[Limited Sample] then mark the field as 'must be unique' which will prevent the combination to be duplicated. (give a real mean warning...okay not that mean).
Then put the limited sample in a table and the main samples in another table. Even if I am wrong about the main sample you can use this method to prevent combinations.
1 main sample to be combined with another of 4 samples. The 4 samples are limited so they can only be used once and I assume the main sample is a quantity of 4 since you want to combine it with 4 other samples (separately of course).
I would make a text formula to combine the sample names [Main Sample]&[Limited Sample] then mark the field as 'must be unique' which will prevent the combination to be duplicated. (give a real mean warning...okay not that mean).
Then put the limited sample in a table and the main samples in another table. Even if I am wrong about the main sample you can use this method to prevent combinations.