I have a field that has a the value 1 everytime a condition is met. I want to in another field(one we will be creating) add a condition that says if the value in field1 = 1 then in the next recno() put a 1. How the hell do I do this
Have tried that before, doesnt work. No matter my order by nothing, sadly ): I've concluded that i need to somehow use recno() next... to insert my value. Want to know if anyone has managed to do this?