Hi, I am a relatively new Access programmer, but have programmed computers in Fortran and done complex modeling for years. Am learning quickly, and have managed to figure everything out so far, but now am stuck. Sorry if this is a basic question. I am using Access 2007.

I have a form for data entry. Database is biological samples. One table has sample code, date, other fields. Another table has multiple records for each sample,...