Creating an "audit" table
Hey everyone. I am trying to create a relationship between a table and another "audit" table. The first table has fields containing various chemicals, amounts and procedures related to a certain chemical "recipe". The purpose of the second "audit" table is to ensure that the chemicals, their amounts and procedures found in the first table are followed correctly. This audit table will then have to be given a unique lot # and filed independently of original table. Any instruction in the right direction is appreciated!