Hi! I am new to VFP and really don't know what is the right way. I have asked this question before but I have not seen any reply. I appreciate if someone can help.

I have a master-detail (1 to many) table in a form. The two tables are related via a surrogated key. In the detail table grid, AllowAddNew is set to .T. so that when user presses downarrow, he can go into next line. My question is: Which is the best event I can use to update the detail table surrogated key? It seems stupid if I use afterrowcolumnchange because while the user is browsing, it also runs through the update code. Any better idea?

Many thanks to those who help.


Tai SC