Apply inputfield to select records

[#1]

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!