First off, I'm a complete novice who has been landed with the job of building a Database. Heres my latest problem. I have a Form used to enter order info into a table that will be used to plan production. I would like to have the details of the Product ordered to autofill, once the unique Customer Code & Product Code have been entered into the form (both these fields are the primary key on the source table). Any suggestions would be great as I am running out of hair to pull out.