Bit of a confusing one so i have attached a demo file.
Basically i have 2 tables
I also have a Form
I need it so that when i enter data into
frm_Book_In click add it does the following -
*add a unique id, supplier and number of pallets...