Re: smart tables
yes - but you dont need to do that.
have a form/subform (based on normalised tables, of course)
enter the common details for delivery in the main form. (date, supplier, DN no etc etc)
then in the subform enter the pallet details. Access automatically sets the pallet data that corresponds to the DN record. (ie PK/FK). As I say, it needs you to have set up the tables appropriately.
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.