Hello to whoever is reading this,
I don't have any experience with databases but I've picked up Access to create a statistic process control in my workplace. I can't figure out how to "build" the database with the functionality I seek. I just need someone to send me in a direction and then I'll self-learn; I just don't want to go through hundreds of pages of tutorials to find a solution. I'm self-taught in Excel + VBA and I can get around most of the problems when I need to (using VBA), but I want to know how to design this 'the right way'.
I'll use a flower example to ilustrate my case. This is the main table, "tabFlowers":
ID Flower Color Price 1 ROSE RED 2.60 2 ROSE YELLOW 2.20 3 TULIP RED 1.90
In my form "formLookup", I want to be able to select Flower and Color from two separate drop down lists, each with non-duplicate values. Then I want to autofill a textbox with the corresponding price (to 'look up' the price based on flower and color). What is the correct way to build the form and related components? Could this be achieved "live", just as Flower or Color are selected in the form?
I know this is a very broad question, but I've tried several times on my own and none of my solutions worked well. I wanted to used "DLookup" but I think it only allows to lookup based on a single parameter. I'll be using several parameters in my actual database.
Thank you for your time.