Help Adding Details in a Master / Detail Form (Descending Order)

Applications Forms
#1

Dear Friends,

I knew I read similar thread before but I couldn’t seem to find it. So, please help me again.

I have a Master Form “A” and a Detail Editable Grid View “B”.

  1. In an ascending order SQL in Form “A”. After I add a new record in Form “A”, the app returns to the record I just added and I can immediately add new (detail) records in Form “B”. This is no problem.
  2. Once I change the order (in SQL section of Form “A”) so that now it is descending order. So the newest record is shown first and oldest record is shown last.
  3. Adding a new record in Form “A” does not bring me back to the new record I just added so this means I cannot add new detail records in Form “B”.
  4. I read before in earlier thread but couldn’t find it now. I have to do something like sc_commit_trans and sc_redir (to Form A).

Can you please explain a bit more on exactly what I need to do?

Thanks,

Capecode