I am want to sell auto parts via my website. I would like the following drop downs for my users to select; year, make and model.
I have setup a database with in my website called parts. With in the database are fields that contain, year, make, model and parts associated with those years. I am a beginner at coding even though I took 3 classes in college for it. I get concepts of OOP but each language is unique. We programmed in VB and C++.
Here is how I imagine my pseudo code would work.
Import data from database
Import year from field 1
Filter repeat year
Display year to Drop_down1
If user selection from Drop_down1 == Drop_down2
Filter repeating make
Display make to Drop_down2
Display "No current make for year selected, please select another year"
If user selection from Drop_down1 and Drop_down2 == Drop_down3
Filter repeat model
Display model to Drop_down3
Display "No current parts for model of year and make selected"
If user selection == True
Display field_part to a picture box and display field_price to textbox_1
At the end of the user looking for his auto part I need to create a check out process via Wix store or a plug-in.
Any help would be appreciated or if I can not due what I am looking to do please let me know that also!