Skip to main content ↑ ↓
Topic: value EDIT doesn't change where it is selected  (Read 1530 times) previous topic - next topic

value EDIT doesn't change where it is selected

Hello community,

I have question about auto update to value:

1) Created DB table "Products" with ID, name, price, category
2) Created DB table like "Product_cat" with ID, name
3) Used select box with query for "Products" table and category row.
4) Created product categories with names: cat1,cat2,cat3
5) Created product with name and select category: prod1 and cat2
6) Renamed "Product_cat" cat2 to cat5
7) Information in "Product_cat" changed, but in Products it remains for prod1 (cat2) it just doesn't update in entire DB.


Maybe someone has a solution for it? Or maybe I am doing something wrong?

Re: value EDIT doesn't change where it is selected

Reply #1 –
@zte813 it seems you are storing the category name with the product instead of the category id. from the category select for product make sure you set the id as Value Field and name as Label Field, that should solve the issue.

Re: value EDIT doesn't change where it is selected

Reply #2 –
Check out this video tutorial on youtube
https://youtu.be/9h0ImxIPc4A