I have a listbox with two columns in it. Period and Code. The listbox is set to update into a Students_Schedule_table listed below it. I need to find a way to link the listbox to the table, so if I press a third period class on the listbox, it will update into the third period of that students schedule. The way it is working now, when I click on a value from the listbox it updates into whichever period my cursor was in the table, not neccesarily the matching period.

I hope that makes sense