INSERT INTO SamplesSentDetl
 SELECT LastAutoInc('SamplesSent'), ProdId, Product, PackType, ProdDesc,
Package, UnitSize, Unit, Price
 FROM AvailPrd WHERE ItemId = :ItemId

The definitions of the 3 tables used are listed below
for reference (minus the indexes):

CREATE TABLE IF NOT EXISTS "Availprd"
(
  "ItemId" AUTOINC,
  "ProdId" INTEGER,
  "Product" VARCHAR(30),
  "PackType" VARCHAR(30),
  "VendId" INTEGER,
  "CustId" INTEGER,
  "SalesId" INTEGER,
  "AddrId" INTEGER,
  "Date" DATE,
  "ProdDesc" VARCHAR(70),
  "Package" VARCHAR(15),
  "UnitSize" INTEGER,
  "Unit" VARCHAR(5),
  "Price" FLOAT,
  "Qty" INTEGER,
  "Wanted" SMALLINT,
  "Hot" SMALLINT,
  "Spot" BOOLEAN,
  "SampleSent" DATE,
  "ProductNotes" VARCHAR(200),
  "DateCreated" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY ("ItemId") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);

CREATE TABLE IF NOT EXISTS "SamplesSent"
(
  "ItemId" AUTOINC NOT NULL,
  "DateRequested" DATE DEFAULT CURRENT_DATE,
  "SampleSent" DATE,
  "ProdId" INTEGER,
  "Product" VARCHAR(30),
  "PackType" VARCHAR(30),
  "VendId" INTEGER,
  "Vendor" VARCHAR(30),
  "CustId" INTEGER,
  "Customer" VARCHAR(30),
  "SalesId" INTEGER,
  "ProdDesc" VARCHAR(70),
  "Package" VARCHAR(6),
  "UnitSize" SMALLINT,
  "Unit" VARCHAR(5),
  "Price" MONEY,
  "Received" DATE,
  "ReceivedBy" VARCHAR(15),
  "PrintingNotes" MEMO,
  "InternalNotes" MEMO,
PRIMARY KEY ("ItemId") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);

CREATE TABLE IF NOT EXISTS "SamplesSentDetl"
(
  "ItemId" INTEGER NOT NULL,
  "ProdId" INTEGER NOT NULL,
  "Product" VARCHAR(30),
  "PackType" VARCHAR(30),
  "ProdDesc" VARCHAR(70),
  "Package" VARCHAR(15),
  "UnitSize" SMALLINT,
  "Unit" VARCHAR(5),
  "Price" MONEY,
PRIMARY KEY ("RecordID") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);