i have combobox that i binding it to the product table in the form load so when i open the combobox i reterive all the products stored in my database so when i want to save order i choose product from combobox not write it because i used the combobox selected value to save the productid in the orders table not the name of the product....
the problem i have currency manger on that form so i use nevigate button to move between orders so i must have to bind the same combobox to order_details table so when i use nevigate buton it dir the correct product name so i must bind this combbox to 2 tables products & order details and i thnik this impossibole so what is the right soulation to my problem
my right paln is when i open the form that combobox have all the products name stord in my database and whan i use nevigate button the combobox dir the name of product name belong to the current row