Hello,
My problem is that I would like to filter one of my combo boxes (ID_format) based on the selection of another combo box (ID_produit).
ID_produit = product name
ID_format= available product sizes
ID_produit_prix = price of the product depending on the size
When a user selects ID_produit, I only want the product sizes that have a price associated withthem to show up in ID_format... but instead all of them show up.
In summary... i want: ONLY SHOW ME THE SIZES THAT HAVE A PRICE ATTACHED TO THEM BASED ON THE PRODUCT SELECTED.
P.S. cascading combo boxes don't work because it is a continuous form. Thank you.