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 to
tbl_Book_In (it already does this)
*(Tricky Part) I need it to then depending on the value of "Number of Pallets" Field - add that many entries into tbl_Pallet_Location with the same Delivery reference but their own unique Pallet ID's.
It may sound ridiculously confusing as it is hard to put it into words, any help is much appreciated and i will be available on msn for about an hour so please add ltpr1 @ hotmail.com (without spaces) on msn and i will provide more details or just reply to this post
thanks again
Lee
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 to
tbl_Book_In (it already does this)
*(Tricky Part) I need it to then depending on the value of "Number of Pallets" Field - add that many entries into tbl_Pallet_Location with the same Delivery reference but their own unique Pallet ID's.
It may sound ridiculously confusing as it is hard to put it into words, any help is much appreciated and i will be available on msn for about an hour so please add ltpr1 @ hotmail.com (without spaces) on msn and i will provide more details or just reply to this post
thanks again
Lee