I have a database of products.  Each product has a few related sub tables like a bill of materials, prices based on different order quantities, customer item number cross-references, dated comments, etc. The Product ID number is the unique primary key (this is not an auto number field). Often, we have to create new products that are nearly identical to an existing product.  Is there a video or a way to create a button on the Product Form where it will prompt me to enter a New unique Product ID, and then copy every other field and the sub records from the current product to the new product with the new product ID I entered when promted?