Pulling information from one table to another and creating new records

Discussion created by RandyHandley on Mar 11, 2016
Latest reply on Mar 12, 2016 by siplus

So I have an inventory database that has several different tables with many different relationships.  What I am trying to figure out how to do is perform a find in my table "piece list" and then have that found set create new records in the table "Check in".  Each record in the piece list table is a different item.  What I want to do is to be able to check this item in everyday and have a record of it.  I am not certain if I am going in the right direction having two different tables for this.  I don't want to create duplicate records in the piece list table.


Any help would be great!