Basically when a delivery arrives it will have a number of pallets in, i need it to enter in the delivery number , supplier, no of pallets in the tbl_Book_in and then create the amount of line needed in tbl_Pallets so that each pallet is accounted for with its own unique pallet reference but...