Hello,
I have two combos in the lightbox. In the first combo ( combo1), I show all the records of the table “partner” from a Postgre db table, but in the second combo ( combo2) I need to show only the invoices of the partner selected in the first combo, How can i send the partner_id (id_combo1) value to the combo2.php ( connector ) to use this value in the sql query to filter these records?
Example :
combo1 : Partner1
combo2 : ( only should show the Partner1 invoices )
Any idea?
( This is my query in the combo2.php)
“Select id_invoice, total_invoice from invoices”
And I think it should be…
“Select id_invoice, total_invoice from invoices where id_partner = partner_id”
I’m testing with this example (samples/02_customization/26_linked_selects_in_lightbox.html ) but i dont know how to do it with sql querys.
Thanks
Jorge.