First off, I'm not sure if this is the correct thread to be posting in so if I need to delete and re-post in a better location please let me know.
Now on to the questions I have. I work at a Winery and have recently taken over the reporting side of things and I was thinking that access would be perfect for what I'm doing (making use of spreadsheets that could be connected). I will give an example of the spreadsheet that I would like to try and mimic. My goal is to create a forum that I can enter a few different variables in and from those variables it will fill in the following blanks (PLN,TIN,Address,state,zip,ext.). I want to be able to enter the Store name and then from that it would auto pull up the above stats. Is this possible from just one drop-down menu? I would assume so, as all these stats are connected.
Image of what i want it to look like.