Hi QV Community,
I have a table that has Region and Product. What I want to do is apply a value to an inputfield called flag to some or all distinct products within the selected region.
So, if I have 5 regions, and I input a flag #, but I only want this flag to apply to 4 of the 5 regions, how can I do this? I am trying to avoid using a macro. I am trying to make it work based on what is selected.
For example, I only want to input flag = 1 for region 1 to 4 as seen below. How can this be based on my selection and avoid the user having to input flag = 1 four times?
Region | Product | flag
1 a 1
2 a 1
3 a 1
4 a 1
5 a 0
Thanks for your help!