I have a form in which customers can submit testing with me. There are multiple test methods they can choose from, and they may want multiple methods on the same sample.
This in and of itself isn't the issue, the issue arises from the fact that they may want different amount of test runs per method, but all on the same sample. E.g. Sample 1 comes in for Method A (2runs), Method B (1run)--> As can be seen by PersonB with sample2 in the screenshot below.
How can i set up the input form to prompt them for a runs value (and sample value-See screenshot) when they select the method, but also have it so the table displays/holds the information in a single record per method, as shown in the table below?
At the moment they need to add a single method at a time for it to achieve what i have so far.
Note: The methods dropdown box on the form is bound to a different table that only contains the methods so we can allow them to only pick methods we either have available or are in service at that time.
^The submit button saves the data to the table and clears the form to display what is seen above, the Delete button just clears the form. LabBatchID is also an autonumber, that's just handy for us to be aware of.
Any help would be great and much appreciated, if you have any specific questions please let me know.
Kind regards, Ben