AnsweredAssumed Answered

Creating an "audit" table

Question asked by JantzSelk on May 18, 2011
Latest reply on May 18, 2011 by philmodjunk


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!