Hello, i am new to progrmaming in MS access 2007 although i have some basic programming in C++, Java, Pawn and some web design languages (PHP, xHTML, CSS, Javascript).
for my database i need to make it so that when i enter the Product Name from a dropdown menu it gets the product ID from another table.. (so, I choose product name "shoe" then it queries the "qry_Products" table for the product with the name as "shoe" and then gets the ID.."PA01" for example... and puts it into the Product_ID in the original table where i chose the name from the drop down menu... )
Im pretty sure i need programming in access to do this or maybe even macros?... Ive already made a query which can do this for all my records although i have to run it manually and this causes problems..
-thanks