I am developing a Certificate of Analysis (COA) database that will contain the test results of all incoming raw materials we use.
Each raw material always has a certain number of tests in each of their respective COAs. I have a table of all the raw materials we use and their tests.
I want the database to have an append query that adds the test names when a raw material criteria is entered (so the lab tech doesn't need to do it manually every time).
I am able to design the query correctly but want the data entry form to bring the lab tech to the newly appended test names so he/she can enter the test results. Is this possible?
Each raw material always has a certain number of tests in each of their respective COAs. I have a table of all the raw materials we use and their tests.
I want the database to have an append query that adds the test names when a raw material criteria is entered (so the lab tech doesn't need to do it manually every time).
I am able to design the query correctly but want the data entry form to bring the lab tech to the newly appended test names so he/she can enter the test results. Is this possible?