G
Guest
ok i have a table "products" that has "quantity" field. i also have a form
that takes data from "order" and "order detail" tables. now when i open the
form i chose for example the customer and that is taken from the customers
table and then automatically it will fill the address and info about the
customer. now the part i have question on is that when the i choose which
items the customer to buy i want in the quantity combo box to display for
example (1-10) if the product they have chosen which was taken from products
table has a quantity of 10. also after submit i want the product table to be
updated to equal the number - the sold.
that takes data from "order" and "order detail" tables. now when i open the
form i chose for example the customer and that is taken from the customers
table and then automatically it will fill the address and info about the
customer. now the part i have question on is that when the i choose which
items the customer to buy i want in the quantity combo box to display for
example (1-10) if the product they have chosen which was taken from products
table has a quantity of 10. also after submit i want the product table to be
updated to equal the number - the sold.