Tkinter autocomplete retrieving other matching attributes and displaying on selection of option

01:38 Understanding the concepts with example
05:45 Adding / changing the code to include other
08:12 testing the code
09:08 Change in layout adding labels to display mark and class
13:49 Adding display data to Labels by using config()
15:18 Final demo showing the mark and class of selected student
15:29 Trying different data sources
17:14 Change the data source to MySQL
18:23 Concept of adding entry box


When we select out of the different options we will display other attributes of the row. For example when we select one student name, we will also display the student mar, its class etc . To do this we must have data in different format than the list with only one column.
Here is one sample list .
my_list=[(1, 'John Deo', 'Four', 75, 'female'),
(2, 'Max Ruin', 'Three', 85, 'male'),
(3, 'Arnold', 'Three', 55, 'male'),
(4, 'Krish Star', 'Four', 60, 'female')]

Here we will show the names as options and then on selection we will display the mark and class of the selection.
Here also data source can be anything , we can create the above formatted data by taking source from SQLite or from MySQL or from google sheet or from CSV file.


Part I : Design , adding options and selection
   • Tkinter Autocomplete by using Entry and Li...  
Part II : Navigation and selection by arrows
   • Tkinter Autocomplete using down up arrow t...  
Part III : Different data sources, Pygsheets , MySQL database
   • Tkinter Autocomplete options using date so...  
Part V: Using colour names as source
   • Tkinter autocomplete to browse and select ...  


Source code is here
https://www.plus2net.com/python/tkint...

SQLite database download from here
https://www.plus2net.com/python/sqlit...

MySQL dump for student table
https://www.plus2net.com/sql_tutorial...



#connectedAttributes #otherparameters #selectedParameters #TkinterAutocomplete #ProductDetails #python #plus2net