Hi @Justin_Cain - I recommend this as a base design for the scenario you describe:
3 tables - Pallets, Pallet Items and Products. It all comes together in the Pallet Items table, which has linked fields to both Pallets and Products:
This is the place where you can add your code date to each product on a pallet