I have two tables that is one to many relationship. Each patient has multiple tests (4 tests). Three (test 1,2,and 4) of the 4 tests (sorted by brand names) will be tested on the same date, and the third test can be tested on different date. I do not want the end user to enter the same dates three times. What is the best way to handle this? Below is the portal, and test 1,2,4 were tested on 10/13/2017, and third test was tested on 10/20/2017.
Any suggestions? Thank you in advance.