Originally posted by jmrSudbury
Do this in Vba. loop through a recordset of your flat file. rsR.Add to your tbl_Record and after setting the product field trap the autonumber assigned into a local variable:
Do the same for inserting into the Forcast Detail table and trap the ForecastDetailID. You can now insert into your third table.
Thanks, for that tip. If you won't mind can you please give sort of sample code, because i don't know how to use DAO in vba, but if i have any sample code and can twist around the code to make it work.
Thanking you in advance.