I don't like the idea of troubling the user to add child record shown in the samples. Therefore, I use AllowAddNew=.T. in my child grid. To maintain the 1-many relationship, I use a surrogated key. My question is: what is the best time to update the surrogated key to the child table so that the 1-many relationship is kept. I have to update the key some time after VFP automatically append a record, right?

I also read that we can use a denormalize view for the 1-many form, ie. an updateable view of master-detail. Is that a better way? Any disadvantage?