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!