Questions: These pg#1 and pg#2 -- are those actual APEX pages?
When I use PREV and NEXT, it has been exclusively for changing the rows displayed on a particular page. That is, I stay on the page but the pagination changes. Say, first it has records 1-10. I press NEXT and get records 11-20 but it's still the same page.
I'd choose different buttons to change pages. But maybe it amounts to the same thing either way you do it. If you need certain functionality the first time you change pages but not the second time, you will have to track when is the first NEXT press versus the next NEXT press and only allow the validations to fire the first time. Maybe you need a First Time Flag as part of the validations conditions. And the validations only fire the first time -- until they are reset.
thanks for the reply
Yes they are actual page numbers.
I think i might need to use conditions for the custom insert process