3 Replies Latest reply on Mar 12, 2016 3:26 AM by siplus

    Pulling information from one table to another and creating new records

    RandyHandley

      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!

       

      Thanks,

      Randy