>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
Hi, Tai SC
I saw your previous message, but didn't think of this until today: Could you trap the down-arrow keystroke in your AfterRowColumnChange and add the surrogate key then? You would need a several steps:
1. Dodefault() (I'm assuming VFP5 since VFP3 didn't have AllowAddNew).
2. Check to see if your surrogate key is blank and add the correct value.
3. Refresh grid if needed
HTH
Barbara