Master-detail Form

[nickty]

Hi, I wondered if anyone could help?

I have a master detail relationship, and the detail contains year. This table will have values for previous years, next year, and the current year. How do I get the form to display the CURRENT year, but allow users to scroll up to next year or down to previous years.

If I do an order-by, I get the greatest year (not current).
If I do a where :year := :global.year then I only get that year, and the user cannot scroll to any other year.

Does anyone have any ideas?
thanks.

 

[sem]

You may edit on-populate-details trigger (or query_master_details procedure) to navigate to the record you need and then return to master block.

Regards, Dima