It's possbile to filter a listbox with another listbox
Posted: Mon Jun 24, 2013 9:38 am
Hi to everyone,
i'm trying to create a form with 2 listbox that write something in 2 fields (let's call them "fieldB" and "fieldC") in the table "tableA".
Those 2 listbox (listboxB and listboxC) are linked with 2 different tables ("tableB" and "tableC").
The listboxB list the values of the field "idB" of "tableB" and write the selcted value in the field "fieldB" of "tableA".
The listboxC list the values of the field "idC" of "tableC" and write the selcted value in the field "fieldC" of "tableA".
"tableB" and "tableC" have a relation one to many with the unique field "idB" in "tableB" that relate to many record "idB1" in "tableC".
What i'm trying to do, is to have the list shown in the listboxC filtered by the above relation, so when the user select a value of "idB" in the listboxB, the list shown in the listboxC contains only the value where "idB1" = "idB".
I thank in advance for any help!
i'm trying to create a form with 2 listbox that write something in 2 fields (let's call them "fieldB" and "fieldC") in the table "tableA".
Those 2 listbox (listboxB and listboxC) are linked with 2 different tables ("tableB" and "tableC").
The listboxB list the values of the field "idB" of "tableB" and write the selcted value in the field "fieldB" of "tableA".
The listboxC list the values of the field "idC" of "tableC" and write the selcted value in the field "fieldC" of "tableA".
"tableB" and "tableC" have a relation one to many with the unique field "idB" in "tableB" that relate to many record "idB1" in "tableC".
What i'm trying to do, is to have the list shown in the listboxC filtered by the above relation, so when the user select a value of "idB" in the listboxB, the list shown in the listboxC contains only the value where "idB1" = "idB".
I thank in advance for any help!