How to open a window by clicking on a column in a tree view table?

Question

How would you double click on a column in a tree view table to then display the specific records on entry fields on a new window.

def SearchCustomer(self):
            connection = sqlite3.connect("Guestrecord.db")
            cursor = connection.cursor()

            columnID = ["GuestID","title","firstName","surname","dob","payment","email","phoneno","address","postcode"]
            columnStr =["GuestID","Title","FirstName","Surname","DOB","Payment","Email","PhoneNo","Address","Postcode"]

            self.search_table = ttk.Treeview(self.search_frame,columns=columnID,show="headings")

##            self.search_table.bind("<Motion>","break")

            for i in range(0,10):
                self.search_table.heading(columnID[i],text = columnStr[i])
                self.search_table.column(columnID[i],minwidth = 0, width = 90)
            self.search_table.place(x=0,y=0)

            for GuestRec in cursor.execute("SELECT * FROM tb1Guest1"):
                self.search_table.insert("",END,values=GuestRec)

            self.search_table.bind("<Double-1>", self.OnDoubleClick)

            connection.commit()
            connection.close()
        SearchCustomer(self)
        sqlCommand = """
           CREATE TABLE IF NOT EXISTS tb1Guest1
           (
           guestID INTEGER NOT NULL,
           guestTitle TEXT,
           guestFirstname TEXT,
           guestSurname TEXT,
           guestDOB DATE,
           guestPaymentType TEXT,
           guestEmail TEXT,
           guestPhoneNumber INTEGER,
           guestAddress TEXT,
           guestPostcode TEXT,
           primary key (guestID)
           )
        """

        self.search_firstname = Entry(self.search_frame2, width=25,bg="#e2f0d9",font=("Avenir Next",18),highlightthickness = 0,relief=FLAT)
        self.search_firstname.place(x = 140, y =0)
        self.search_firstname_label = Label(self.search_frame2,bg = "white", text = "First Name", font=("Avenir Next",20))
        self.search_firstname_label.place(x= 30,y=0)
        self.search_Surname = Entry(self.search_frame2, width=25,bg="#e2f0d9",font=("Avenir Next",18),highlightthickness = 0,relief=FLAT)
        self.search_Surname.place(x = 540, y =0)
        self.search_Surname_label = Label(self.search_frame2,bg = "white", text = "Surname", font=("Avenir Next",20))
        self.search_Surname_label.place(x= 450,y=0)
    


##      Binding entries
        self.search_firstname.bind("<KeyRelease>",self.Search)
        self.search_Surname.bind("<KeyRelease>",self.Search)

    def OnDoubleClick(self, event):
        self.gf_window.destroy()
        self.search_results()

This is the my code for displaying my records in my search tree view table. I am able to double click on a column to then bring up a new window but I am unsure how I would display the specific records on my entry fields I am making on the new window? If anyone could suggest a solution to this torment it would be much amazing. Thanks in advance.

Answer 1

You should be able to grab the selected Treeview item from the mouse event being passed to your OnDoubleClick() function. If you want to open a new window that's a child of your root window, you'll want a Toplevel widget. You can treat that Toplevel window pretty much just like you would a root Tk window.

# side note: this should really be named "on_double_click" by convention
def OnDoubleClick(self, event):  
    tree = event.widget  # get the treeview widget
    region = tree.identify_region(event.x, event.y)  # get click location
    iid = tree.identify('item', event.x, event.y)  # get item ID

    if region == 'cell':  # i.e., if the click wasn't on the header row...
        data = tree.item(iid)['values']  # get the item data
        window = Toplevel(self)
        window.transient(self)  # optional: hide window controls except [x], pull focus
        # whatever you want here...
        window.geometry = '400x600'
        window.title('Results')
        label = ttk.Label(window, text=data)
        label.pack()
        # yadda yadda...