"2-way relation" possible?

I have a categories sheet and a products sheet, every product belongs to a certain category,
what I would like the app to do is that when the user modifies the name of a certain category in the categories sheet, the category of all related products will change accordingly in the products sheet.

I feel there is an easy way to do it but I can’t grasp it. Thanks if you will help

1 Like

What are you looking to change specifically? Can you give us a specific scenario—there are a few solutions depending on what you’re looking to do.

Thanks for answering;

I would like that when the user modifies the name of a certain category in the categories sheet, the category of all related products will change accordingly in the products sheet

1 Like

To do that, you’d probably really need two “categories” a unique category ID (the one that works behind the scenes as the true “category” and then a category display field that’s what’s seen by the user. Any other than this will break relations between the sheets when the category is renamed.

2 Likes

I think I’d have the user that created the category to manually insert the category two times in that case, and in the products category display it would be a look up?

1 Like

correct.

1 Like