I have a form with these fields:
1)Product
2)Qty
3)Area
In the area field there is 3 options:
1)GAU
2)WC
3)NAT
The problem i am sitting with is that say in record 1 i will have GAU in the area field and in record 3000 I will have WC in the area field.
I now need to update all the records(empty) in between that will belong to GAU.
But I need it to stop updating when it gets WC, and then it needs to fill the area between WC and NAT with WC!
How will I be able to do that???
1)Product
2)Qty
3)Area
In the area field there is 3 options:
1)GAU
2)WC
3)NAT
The problem i am sitting with is that say in record 1 i will have GAU in the area field and in record 3000 I will have WC in the area field.
I now need to update all the records(empty) in between that will belong to GAU.
But I need it to stop updating when it gets WC, and then it needs to fill the area between WC and NAT with WC!
How will I be able to do that???