Automatically populate a field in a new table
I'm trying to create a database that allows tests to be assigned to a single sample ID. Right now the database is set up so that a sample number is automatically assigned in one table, in which information about the sample is input. Then a button is used to open a new table in which sample tests are put in for each sample ID. Right now it is set up so when the new form opens I have to input the sample ID, then assign the test. If I have 10 tests I have to do this 10 times.
What I want to do is build a table that allows me to click a button, on the initial sample entry, and the sample ID will autopopulate the field in the new table, where all of the tests can be entered at once.
Thanks for your help.