Hi, I am working on a form right now. I have three tables: tbl_projects --projectID --projectname --projectdescription --projectmanager tbl_products --productID --productname --productshortname --productcategory tbl_projectproducts --projectID --productID The form is used to enter a project, it has multiple fields (i.e. project name, project manager, project description). Only when the project is entered into the database, can I retrieve the autonumber (primary key) to use to insert values into the projectproducts table. Is there a way to retrieve the value on the same form? so that i can enter the product info right away, besides going to a new page? thanks!