I am creating a database that will store analytical data from a variety of sites. Each site has different monitoring requirements. Each file number will have many sample locations. I would like to have a macro to look up the file number and then display the form with required monitoring. Each form would represent one sample event. After filling in the data, I would like to be able to go to the next record and have the same information come up on the form (preferably without doing another search).
My initial thought was to have a table with each file number and required monitoring and use this to look up the information for the form. Then have the form populate a master table with all of the data from each file number's multiple monitoring locations. However, a brief search online looks like there may be a better way to do this.
Thank you for any help!