No announcement yet.

Alternative to lookup

  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    It's a good and logical question. But I simply don't know the answer. Of course you can put some code in the onafterinsert. But you have to close the form and pass the data. I suggest you look in the generated code to see what's behind the select button. Then you should be able to perform the automatic select of the latest added record. I think this is a serious issue to be put highly on the wishlist. Another untried option is to set the sql statement to this last insert. Then you will have a list of only one item. Still need to hit the select, but you skip the search. Not perfect, but better....
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development /


    • #17
      Thanks Albert. I think the best solution at this point is to set the sql statement as you suggested. So I would do that in the onafterinsert event? And if so, how would I know the ID of the newly inserted record?