HI,
Bit of a confusing one so i have attached a demo file.
Basically i have 2 tables
tbl_Book_In
tbl_Pallet_Location
I also have a Form
frm_Book_In
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...