Hello guys, just need a little help about the proper communication between 2 web listboxes.
Tables/data that needs to be fetched from the database:
*Listbox #1 -> Table #1
*Listbox #2 -> Table #2
B_code, D_code, randomdata1,randomdata2,randomdata3,randomdata4,random5
*D_code from Listbox#1 is the same with Listbox2,
*There is only one unique D_code in ListBox1 but there are duplicates in ListBox2
What i wanted to happen when the webpage load/shown:
*Listbox #1 will fetch the data of table #1 from the database, but Listbox #2 will be empty/or will not show anything by default. (of course this is easy)
The main task is:
*If a user select a single row in Listbox #1, then ListBox #2 will only fetch data with the same D_code of the selected row in ListBox1.
For example ListBox1 fetched these data:
D_code1 | RandomData1 -> selected
D_code2 | RandomData2
D_code3 | RandomData3
Let just say that a user selected the row with the D_code1, then ListBox2 will fetch/show this:
B_code1 |D_code1 | RandomData1| RandomData1 | RandomData1 | RandomData1| RandomData1
B_code2 |D_code1 | RandomData2| RandomData2 | RandomData2 | RandomData2| RandomData2
B_code3 |D_code1 | RandomData3| RandomData3 | RandomData3 | RandomData3| RandomData3
B_code4 |D_code1 | RandomData4| RandomData4 | RandomData4 | RandomData4| RandomData4
B_code5 |D_code1 | RandomData5| RandomData5 | RandomData5 | RandomData5| RandomData5
Only the data with the same D_code was shown.
If selection changed, (D_code2 was selected) then all of the data with D_code2 will be shown and so on.
Do i need to make another query which will be the one responsible for fetching in ListBox2 ? or i can do it in Xojo only?
*will not be using plugins by the guys.
*i just need a guide since i’m new to xojo,