I have an UDO form, whose Code value in master table should be automatically incremented.
So, when the user switches to ADD Mode, I find the next Code value with a query and update the related field on the form. ( SQl Select max (code) from .... etc )
Untill here everything is ok. When Add button is clicked, data is saved to database.
<b>BUT</b> when I navigate through the records using the Next and Previous buttons, that added record is not listed.
It exists in related table, since
1. I can see it in SQL Server.
2. It's listed with the details just as I entered, when I use <b>Find</b> button on the form <b>with "*"</b>.
<b>What may be the reason why these records aren't shown with prev & next buttons ?</b>